Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a Figures into text in my excel exp. 200-two hundred
how can i change figures into text in my excel sheet
for example 200 becom tow hundred, 3200 become three thousand two hundred |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a Figures into text in my excel exp. 200-two hundred
Look here for several solutions:
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Kems" wrote in message ... | how can i change figures into text in my excel sheet | | for example 200 becom tow hundred, 3200 become three thousand two | hundred | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a Figures into text in my excel exp. 200-two hundred
This link shows two methods:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Hope this helps. Pete On May 17, 2:10*pm, Kems wrote: how can i change figures into text in my excel sheet for example * *200 * becom tow hundred, 3200 * become three thousand two hundred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change word 500 to text five hundred | Excel Worksheet Functions | |||
How do I change automatically figures into words in Excel | Excel Worksheet Functions | |||
can I replace £200 by text eg.two hundred pounds | Excel Discussion (Misc queries) | |||
How do I convert number 123 to text One Hundred and Twenty Three? | Excel Discussion (Misc queries) | |||
change a number (100) to word (i.e Hundred) | Excel Discussion (Misc queries) |