Dear Sir,

When i enter "100000" it shows "One Hundred Thousand Rupees and No Paise"
actually it should show "One Lakh and No Paise"

Please help


"Soundar" wrote:

Hi,

Just check the below link,

http://support.microsoft.com/kb/213360

this will give you some idea.

Regards,
Soundar.



"VIVEKMANE" wrote:

If i enter any number "101000" in one cell
I want other cell to show in word "One Lakh one thousand only".

Is there any formula for this

Please help