To Convert Amount Figures Into Text

[PR Pillai]

I am generating manual invoices to my clients, so when I am putting the total
at the end of the page in figures, I need the same to appear in words also.
For Example If I am making a bill of $1500. It should appear in the bottom
line as Dollars 0ne Thousand Five Hundred only. If incase there is a decimal
it should appear accordingly. Please any one can help me by providing a
valuable suggestion.

Thanks
PR Pillai

 

[Bob Buckland ?:-\)]

Hi P.R.,

What program and version are you using?

In Excel you may find the information here helpful.
http://support.microsoft.com/kb/213360
In Word you may find this SmartTag to be useful
http://microsoft.com/downloads/details.aspx?FamilyID=3819A67F-9EB9-4368-85DB-8D117558A0E3
although it does convert decimal numbers it wasn't set up to do currency well after the decimal point (The add-in works in Word 2003
and Word 2007 as well as in Word 2002 as listed on the download page).

=========
I am generating manual invoices to my clients, so when I am putting the total
at the end of the page in figures, I need the same to appear in words also.
For Example If I am making a bill of $1500. It should appear in the bottom
line as Dollars 0ne Thousand Five Hundred only. If incase there is a decimal
it should appear accordingly. Please any one can help me by providing a
valuable suggestion.

Thanks
PR Pillai>>
--

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*