Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Digits to text
Hello Everyone,
This is my first time. Maybe some one has opened this topic already. How do I automatically convert digits to text for example 1234 as "One thousand two hundred thirty four". There is a command available as Bahttext() for the same but it converts the same in Thai text. Can anyone help me? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Digits to text
Manju, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Manju" wrote in message oups.com... Hello Everyone, This is my first time. Maybe some one has opened this topic already. How do I automatically convert digits to text for example 1234 as "One thousand two hundred thirty four". There is a command available as Bahttext() for the same but it converts the same in Thai text. Can anyone help me? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Digits to text
try it
http://www.j-walk.com/ss/excel/usertips/tip002.htm -- regards from Brazil Thanks in advance for your feedback. Marcelo "Manju" escreveu: Hello Everyone, This is my first time. Maybe some one has opened this topic already. How do I automatically convert digits to text for example 1234 as "One thousand two hundred thirty four". There is a command available as Bahttext() for the same but it converts the same in Thai text. Can anyone help me? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy text from one workbook to another | Excel Discussion (Misc queries) | |||
Text File creates incorrect Date format | Excel Discussion (Misc queries) | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |