convert figure into word

G

Guest

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
 
G

Guest

Ankur said:
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
Click to expand...
 
A

anne asha jyothi

Ankur said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to convert nos from figures to words 3
how do i convert numbers in figures into words? 1
convert figures in to word example 350/- three thousand and fifty 3
how can convert the figures in to the word in excel 7
Converting values which are in Numeric format to word format 1
Figures in words 2
how to convert the numeric or amount in figure to word or inwords 2
how do i convert figures into words in excel? 2

Top