how to convert numbers into figures in excel

[arun hatankar]

hi

I want ur help regarding conversation of numbers into fugures in
excel in Indian currency for example if i have to convet

125350 into One Lakh Twenty Five Thousand Three Hundred Fifty Only.

pls mail ur reply to (e-mail address removed)

Waiting for ur reply

 

[Frank Kabel]

Hi
This is common question. Try doing a Google search and you'll find many
macros/procedures. Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods