Tuesday, April 29, 2014 – Permalink –
Numbers to Words
From the Microsoft Knowledgebase collection:
How to Convert a Numeric Value into English Words
This support article contains the VBA code needed to create a User Defined Function, You can, then, change 32.50 into "Thirty Two Dollars and Fifty Cents" by entering something like the following formula into a cell:
From John Walkenbach:
If you use Excel 2002+, you may have discovered the new BAHTTEXT worksheet function. This function converts a number to Thai text, and adds a suffix of "Baht".
This is the only built in function that translates numbers to words and then only in Thai.
For Access see:
Access- Numbers to Words
To create cardinal numbers in Word, see:
Word - Numbers to Words
See all Topics excel
<Doug Klippert@ 3:54 AM
Comments: Post a Comment