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