Press ALT+F11 on Excel then goto Modules below on left and paste the notepad text attached here. Save, close and come back to excel. then in formula for cell type =ntow(cellreferance) [e.g. =ntow(A2) or = ntow(4168 ).
Thats it.
From India, Mumbai
Thats it.
From India, Mumbai
This is very good. I used to write a code using Hlookup, but this is more convenient Hats off.
From India, Madras
From India, Madras
Sorry, when using this ntow this command, these command only using particular Excel Sheet, When Open New Files, This Command Not Be Run, Pl suggest.
From India
From India
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.