| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding "and" to Spellnumber code
Here in Australia $261,345 would be written as "Two hundred and sixty one
thousand three hundred and forty five dollars" Note the two "ands" in there. Can some kind soul tell me how to modify the Spellnumber routine to do this. I've tried but can't get it right with either too many, or not enough "and"s appearing, or appearing in the wrong place. (Its interesting that we say "two hundred AND one" or "two hundred AND sixty one", but we don't say "forty AND five") Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
| Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
| close form code | Excel Discussion (Misc queries) | |||
| bar code help, adding asterix to reference | Excel Discussion (Misc queries) | |||
Threaded Mode
