Figures in words

[Sai Krishna]

Hi,

I would like to know how we can have a cell that returns the figures in words.

For example, you enter 25800 in a cell, the words "Twenty Five Thousand
Eight Hundred" should appear in another cell. This feature will help prepare
invoices that has to show the final invoice value in words as well.

Regards
sai

 

[Ron Coderre]

There are several websites that can help you.

Here are a few:

There's a NumsToWords() user defined function (UDF) file you can
download at this website:
http://www.contextures.com/excelfilesRon.html

The file is completely unprotected, so you have full access to all of the
VBA code. That file has a button that will export the NumsToWords program
into any open workbook you choose.

Or...If you're interested in a non-vba approach, just download the
tiny (19 kb) file from this website:
http://www.contextures.com/excelfilesRon.html

The file includes instructions on how to use it and how to put it into other
workbooks.
.....there are no links to other files and no VBA macros in the file.

and...here are couple other options:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
http://www.ozgrid.com/VBA/ValueToWords.htm

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Sai Krishna]

Thanks. This was useful.
regards
sai

There are several websites that can help you.

Here are a few:

There's a NumsToWords() user defined function (UDF) file you can
download at this website:
http://www.contextures.com/excelfilesRon.html

The file is completely unprotected, so you have full access to all of the
VBA code. That file has a button that will export the NumsToWords program
into any open workbook you choose.

Or...If you're interested in a non-vba approach, just download the
tiny (19 kb) file from this website:
http://www.contextures.com/excelfilesRon.html

The file includes instructions on how to use it and how to put it into other
workbooks.
.....there are no links to other files and no VBA macros in the file.

and...here are couple other options:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
http://www.ozgrid.com/VBA/ValueToWords.htm

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)