View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Change figures to words

One thousand & ten and cents fifty only

probably not since that is incorrect verbiage.

It would be

One thousand ten dollars and fifty cents

There is code like:

http://support.microsoft.com/?kbid=95640
ACC: How to Convert Currency or Numbers into English Words
The above will work in Excel "right out of the box"

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

Free Addin by Laurent Longre (Morefunc.xll)
has a worksheet function that does this
--
Regards,
Tom Ogilvy


"johnny" wrote in message
...
Hi,

Is there any build in functions that can change figures to words ( i.e.
1,010.50 One thousand & ten and cents fifty only ) or need programming

to
handle this?

Regards,
Johnny