I want to convert numbers into text with a formula like this:
65 Sixty Five
37 Thirty Seven
Is there a table anywhere that I can import to do a lookup table on or does anyone know how to write that formula? I need from one to 99.
Thanks,
RR
I want to convert numbers into text with a formula like this:
65 Sixty Five
37 Thirty Seven
Is there a table anywhere that I can import to do a lookup table on or does anyone know how to write that formula? I need from one to 99.
Thanks,
RR
You could use a Lookup Table or possibly VBA to do this. I think you would need to create your own Table.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Place this code in a Standard module. Then in a cell =SpellNumber(19), replace 19 with any number 1 to 99.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks