| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert figure into word
Hi,
I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert figure into word
useful link:-
http://www.xldynamic.com/source/xld.xlFAQ0004.html somethinglikeant Ankur wrote: Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert figure into word
Click this URL and you will get Macro:
http://support.microsoft.com/default...;EN-US;Q213360 "somethinglikeant" wrote: useful link:- http://www.xldynamic.com/source/xld.xlFAQ0004.html somethinglikeant Ankur wrote: Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert figure into word
"Ankur" wrote: Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert figure into word
"Ankur" wrote: Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert figure into word
i get result in dollar but i want the result in rupee
"anne asha jyothi" wrote: "Ankur" wrote: Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i m manually writing the amount in words. Is there any formula to convert the figures to words? The amount to be written in USD for eg. Two thousand fifty and 50/100 cents. Many thanks in advance. Regards, Ankur |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a .dat file opened in Word to excel? | New Users to Excel | |||
| Convert word table to Excel with bullets | Excel Worksheet Functions | |||
| convert a Word doc into an Excel doc. | Excel Discussion (Misc queries) | |||
| How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
