Try CHOOSE()

with value in A1

=CHOOSE(A1+1,"Zero","One","Two","Three","Four","Fi ve","Six","Seven","Eight","Nine")

If you are looking for currency conversion refer the below link
http://www.ozgrid.com/VBA/CurrencyToWords.htm


If this post helps click Yes
---------------
Jacob Skaria


"kashish" wrote:

I have randomly single nos in column A,
How can I get word by formula in B column for particular no given in A column.

0 zero
1 one
2 two
3 three
4 four
5 five
6 six
7 seven
8 eight
9 nine