Is there a formula in excel to covert an amount in digits to words.(If no, please mail a me a macro for this)?

Question

To cnvert an "amount" written in a column to "amount in words" in next column. No knowledge in programing .

Answer 1

Well here is a popular link which I had saved from the days of Excel 97. Like a Samurai sword being passed over, here im passing it over to you (chuckle). Use it wisely!!

http://www.ozgrid.com/VBA/CurrencyToWords.htm

.:Fishie:.

Answer 2

it is the worksheet function TEXT. It is listed in the Excel Help.

Answer 3

=SUBSTITUTE(A1,1,"One")

Can be done with the Function
But, u hv to Work a lot on it.