Numbers in Words

[janak]

Friends,



I have a very small query in excel how do we get number in words,eg...one,two,three.......................... ..upto ten thousand


Janak

[BjornS]

Hi,
see a solution in the attached file. Just copy the formulas down as far as you like (they work until number 19.999). Please also check spelling etc, since English is not my mother tongue.

Kind regards
Bjorn

[janak]

Thanks Bjorn

I little more can phrase it more simple way if possible......