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
--
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

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

"Tom Ogilvy" wrote in message
...
I did some tinkering with the code to insert "and" where necessary


You have to be careful with insertion of the word AND. For example saying

one hundered and thirty-five dollars is incorrect.

it should be one hundered thirty-five dollars

This is a fairly common error.

--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
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

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



"Cecilkumara Fernando" wrote in message
...
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

"Tom Ogilvy" wrote in message
...
I did some tinkering with the code to insert "and" where necessary


You have to be careful with insertion of the word AND. For example
saying

one hundered and thirty-five dollars is incorrect.

it should be one hundered thirty-five dollars

This is a fairly common error.

--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
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