Format Figure Dollar to Text Figure

M

Michael Chong

I am having problem with converting number(dollar) to a string(dollar). For
example, $150.00 will convert as "One Hundred Fifty Dollar Only". What
should I do to make it work?

Any idea? Thanks in advance.


Michael.
 
P

Paul B

Michael, 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 2000 & 2003
** remove news from my email address to reply by email **
 
Top