| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
number to text
hi guys ive tried to search the forum to find the answer but the search function is not working or u can say its kinda dead slow, so forgive me if its been asked before. how to convert an amount(number) to text. eg: 1234 one thousand two hundred thirty four i tried a formula called BAHTTEXT, its supposed to do the job but the language is diffrent, help page says i must change the reginal option in Cp but i cant find a usefull thing there. i also found many articals on google search saying to the cell formating trick, but it doesnt do any thing. -- torpido ------------------------------------------------------------------------ torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482 View this thread: http://www.excelforum.com/showthread...hreadid=397468 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
| Format Number to Text | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Threaded Mode
