| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency to text
I have a column with a list of numbers in currency format (No decimal places)
i.e £168,995. Is it possible to automaticaly convert this in excel to text, i.e. One Hundred and Sixty Eight Thousand Nine Hundred and Ninety Five Pounds, if so how? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency to text
http://xldynamic.com/source/xld.xlFAQ0004.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "Caspar" wrote in message ... |I have a column with a list of numbers in currency format (No decimal places) | i.e £168,995. Is it possible to automaticaly convert this in excel to text, | i.e. One Hundred and Sixty Eight Thousand Nine Hundred and Ninety Five | Pounds, if so how? | | Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text box positioning, printing and between loads | Charts and Charting in Excel | |||
| changing cell values with text and currency | Excel Discussion (Misc queries) | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Formatting a text box to display as currency | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
