Change figures to words

  • Thread starter Thread starter johnny
  • Start date Start date
J

johnny

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
 
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
 
Tom,
This is my reply to you in earlier post by John
regards,
Cecil

Tom, Thanks
In Oxford Advanced Learner's Dictionary 4th edition
Appendix 4 - Numerical Expressions
(In the copy I have page 1522 last line)
1,234,753 One Million, two hundred and thirty- four thousand seven hundred
and fifty-three
Do you mean to say that when dollars comes in that ands have to go away <G>
with great respect,
Cecil
 
Perhaps it is an American thing, but dollars would not change that it should
be:

One Million two hundred thirty-four thousand seven hundred fifty-three

I don't claim to be an authority, but having taught this once as part of a
course, that is my recollection.

--
Regards,
Tom Ogilvy
 
Back
Top