Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to change figures into words | Excel Discussion (Misc queries) | |||
formula to change figures into words | Excel Discussion (Misc queries) | |||
conversion of figures into words | Excel Worksheet Functions | |||
Figures in words | Excel Discussion (Misc queries) | |||
How do I change automatically figures into words in Excel | Excel Worksheet Functions |