To Convert Amount Figures Into Text

[PR Pillai]

I am preparing my invoices in Excel 2003 for my customers, so when I use the
auto sum option for having the total, I need to type the total amount in
words before issuing the invoice to my customers. So I kindly request to
solve this serious issue by giving me an simple example or any inbuilt
fucntions in excel so as to make my work faster & precise.
Thanks,
PR Pillai

 

[Bob Buckland ?:-\)]

Hi P.R.,

You may want to also post this in the MS Office Excel discussion group using the link below if the information on creating the
=spellNumber() functin in Excel, in reply to your previous posting on this topic didn't work for you. You can create/add a function
to do what you want, but it's not a built in one.

=============
I am preparing my invoices in Excel 2003 for my customers, so when I use the
auto sum option for having the total, I need to type the total amount in
words before issuing the invoice to my customers. So I kindly request to
solve this serious issue by giving me an simple example or any inbuilt
fucntions in excel so as to make my work faster & precise.
Thanks,
PR Pillai>>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com