Number to text (Checkbook)

[Guest]

could anybody tell me how to set Excel to write out a
number in English? I need a way for Excel to refer to a
number in one cell/worksheet and turn it into a checkbook
type nuber in another (e.g., "112.19" becomes "One
Hundred Twelve and 19/100" or "One Hundred Twelve
Dollars and 19 cents" ).

Please Help!

 

[Paul B]

Have a look here
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q95640

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Bob Phillips]

http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[Guest]

Thanks, Paul, and sorry for the duplication. I looked at
the article--looks like it will do what I want to. But,
it doesn't put this function in Excel, and I don't know
how to do that either. Little help?

-----Original Message-----
Have a look here
http://support.microsoft.com/default.aspx?scid=kb; [LN];Q95640

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

could anybody tell me how to set Excel to write out a
number in English? I need a way for Excel to refer to a
number in one cell/worksheet and turn it into a checkbook
type nuber in another (e.g., "112.19" becomes "One
Hundred Twelve and 19/100" or "One Hundred Twelve
Dollars and 19 cents" ).

Please Help!

.

 

[Bob Phillips]

It is a function, so it will work in Excel.

Just insert a new module, and copy the code into that. The function can then
be called
form a worksheet or another VBA procedure as shown.

--

HTH

RP

Thanks, Paul, and sorry for the duplication. I looked at
the article--looks like it will do what I want to. But,
it doesn't put this function in Excel, and I don't know
how to do that either. Little help?

-----Original Message-----
Have a look here
http://support.microsoft.com/default.aspx?scid=kb; [LN];Q95640

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

could anybody tell me how to set Excel to write out a
number in English? I need a way for Excel to refer to a
number in one cell/worksheet and turn it into a checkbook
type nuber in another (e.g., "112.19" becomes "One
Hundred Twelve and 19/100" or "One Hundred Twelve
Dollars and 19 cents" ).

Please Help!

.