what is the formula for returning the amount to amount in words

V

Vijay

what is the formula for returning the amount to amount in words

For Example :
in cell A1, if the value entered is USD 1,500
I need a formula which will give the amount in words for the given value
i.e. the answer should be USD One Thousand Five Hundred only
 

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

Converting amount($) of my expenditure into the base currency i wa 1
Autonumber field in Excel that behaves the same as Access 0
Word OLE to check spelling in text box 1
Direct Formula 7
Auto deletion of cell entry in given circumstance 0
complicated excel formula may need an algebra wiz 1
how do i convert numbers in figures into words? 1
Convert numeric values in words. 6

Top