Friends,



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


Janak

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

Attached Files

Numbers_as_text.xls (64.0 KB, 18 views)

Thanks Bjorn

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