Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Change Numbers to Text. ie $1.00 = one dollar
I am trying to convert Dollar amounts into written text in an excel
spreadsheet. How do I create a formula that will convert my Numbers to word text. i.e. $1.00 convert to One Dollar zero cents. $100.00= Convert to One Hundred Dollars and zero cents. -- ABA |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Change Numbers to Text. ie $1.00 = one dollar
Same question as one an hour ago, same answer
You can download add-ins that will do that Morefunc and ASAP-Utilities both can do this both are free, Google them Otherwise see http://support.microsoft.com/kb/213360 -- -- Regards, Peo Sjoblom "ABA" wrote in message ... I am trying to convert Dollar amounts into written text in an excel spreadsheet. How do I create a formula that will convert my Numbers to word text. i.e. $1.00 convert to One Dollar zero cents. $100.00= Convert to One Hundred Dollars and zero cents. -- ABA |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Change Numbers to Text. ie $1.00 = one dollar
Btw, I didn't imply that you asked that same question, if it came across
that way I apologize. -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... Same question as one an hour ago, same answer You can download add-ins that will do that Morefunc and ASAP-Utilities both can do this both are free, Google them Otherwise see http://support.microsoft.com/kb/213360 -- -- Regards, Peo Sjoblom "ABA" wrote in message ... I am trying to convert Dollar amounts into written text in an excel spreadsheet. How do I create a formula that will convert my Numbers to word text. i.e. $1.00 convert to One Dollar zero cents. $100.00= Convert to One Hundred Dollars and zero cents. -- ABA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change text to numbers | Excel Discussion (Misc queries) | |||
Why won't my cells change from Text to % or Numbers | Excel Discussion (Misc queries) | |||
the numbers are always in text and i cant seem to change them??? | Excel Worksheet Functions | |||
How do i change the currency from dollar to GB pounds | New Users to Excel | |||
change numbers to text | Excel Worksheet Functions |