Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Numbers to Text
Hi, I use the code available from the Microsoft Web site that converts
numbers to text and it works very well however, I have had requests to add the word "and" in between the thousands and hundreds : example Instead of "One Thousand Two Hundred Fifty Nine Dollars and Ten Cents" as it now shows I Need "One Thousand Two Hundred and Fifty Nine Dollars and Ten Cents With my limited knowledge I realise that you have to add the word "and" to somewhere in the existing code, just not sure where ?? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |