| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert $10.20 to text ...Ten Dollars &20/100
Hi Iliace,
That worked too. Didn't know that format existed.Thanks!! "iliace" wrote: I'm not sure whether this will work, but why don't you just set the cell's custom number format to "@ **"? This will fill the cell with * characters following the spelled dollar amount, and will always align to cell's width. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert pesos to dollars???? | Excel Worksheet Functions | |||
| How to convert Euro's to Canadian dollars? | Excel Worksheet Functions | |||
| Convert $12.00 to text (Twelve dollars) like you would on a chec.. | Excel Worksheet Functions | |||
| How do I convert $500 to Five Hundred Dollars? | Excel Worksheet Functions | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Hybrid Mode
