View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default About NUM to CHAR

http://support.microsoft.com/?kbid=95640
ACC: How to Convert Currency or Numbers into English Words

http://support.microsoft.com/?kbid=140704
XL: How to Convert a Numeric Value into English Words

So you could write you own function and use that.

You could download Laurent Longre's free addin:

http://xcell05.free.fr/

morefunc.xll

which has a function to do this.

--
Regards,
Tom Ogilvy


"balaneeds" wrote in message
...
I am new in Excel.
I want to convert Number to Character (ie. 1234 to One thousand two

hundred
thirty-four).
Plz let me the procedure.
I use BAHTTEXT() formula but their result I found in Thai Language, I need
result in English.