| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
convert currency to text
how to convert a currency number (for example $100) into a text representing
that number (one hundred dollars only) |
|
#2
|
|||
|
|||
|
http://support.microsoft.com/default...;EN-US;q213360
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Excel_Instructor" wrote in message ... how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only) |
|
#3
|
|||
|
|||
|
Thank you very much for the help you provided .. I really do appreciate it
Regards, Tahani "Niek Otten" wrote: http://support.microsoft.com/default...;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Excel_Instructor" wrote in message ... how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert currency to text
i want to convert "1000" in text like "One Thousand" in excell by formula
is it possible mahbub "Tahani" wrote: Thank you very much for the help you provided .. I really do appreciate it Regards, Tahani "Niek Otten" wrote: http://support.microsoft.com/default...;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Excel_Instructor" wrote in message ... how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert currency to text
mahbub
Yes it is possible. Go to the website Nick provided below and see what is required. Gord Dibben MS Excel MVP On Tue, 13 Jun 2006 03:28:02 -0700, mahbub wrote: i want to convert "1000" in text like "One Thousand" in excell by formula is it possible mahbub "Tahani" wrote: Thank you very much for the help you provided .. I really do appreciate it Regards, Tahani "Niek Otten" wrote: http://support.microsoft.com/default...;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Excel_Instructor" wrote in message ... how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert currency to text
Dear Gord Dibben
Thanks for ur quick response. But i want a solution which i can apply in excel sheet. Nick's solution is very long and i dont know how it apply in excel sheet. if u have any solution regarding this just inform me bye "Gord Dibben" wrote: mahbub Yes it is possible. Go to the website Nick provided below and see what is required. Gord Dibben MS Excel MVP On Tue, 13 Jun 2006 03:28:02 -0700, mahbub wrote: i want to convert "1000" in text like "One Thousand" in excell by formula is it possible mahbub "Tahani" wrote: Thank you very much for the help you provided .. I really do appreciate it Regards, Tahani "Niek Otten" wrote: http://support.microsoft.com/default...;EN-US;q213360 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Excel_Instructor" wrote in message ... how to convert a currency number (for example $100) into a text representing that number (one hundred dollars only) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
| How to convert Numbers to text | Excel Worksheet Functions | |||
Hybrid Mode
