Press ALT+F11 on Excel, then go to Modules below on the left and paste the notepad text attached here. Save, close, and come back to Excel. Then in the formula for the cell, type =ntow(cell reference) [e.g., =ntow(A2) or =ntow(4168)]. That's it.
From India, Mumbai
Acknowledge(0)
Amend(0)
1From India, Mumbai
Acknowledge(0)Amend(0)
This is very good. I used to write a code using Hlookup, but this is more convenient Hats off.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
EXCEL FORMULA.xls