Numbers to spelled out Text

[Paul H]

How can I convert/display the contents in cell A1: 4200.12
into text in cell A2: Four Thousand and twelve?

Similiar to how we present information on a check. We
write the amount and the text version of the amount.

Thank you
Paul

 

[Paul B]

Paul, here is one way
http://www.barasch.com/excel/numb2words.htm

--
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 97 & 2000
** remove news from my email address to reply by email **

 

[Bob Phillips]

Such a frequently asked question, a search of Google would have returned
thousands.

Try this one

http://tinyurl.com/2ua7r

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Paul H]

Works great. Thank you.

-----Original Message-----
Paul, here is one way
http://www.barasch.com/excel/numb2words.htm

--
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 97 & 2000
** remove news from my email address to reply by email **




.