Get HR Software

Figures To Words As Discussed By Amit - TXT Download


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
Attached Files (Download Requires Membership)
File Type: txt ntow.txt (3.9 KB, 520 views)

This is very good. I used to write a code using Hlookup, but this is more convenient Hats off.
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
The script has to be in your modules to enable you to use ntow. The entire script is needed to function. ntow just triggers the script in the modules to make calculations for you and return the value in words. Hope its clear
From India, Mumbai
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.


India, Mumbai
24 March 2009 12.29.41 PM
Views: 2726 Replies: 3 Appreciations: 0



Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.