Formula

[VIVEKMANE]

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

 

[Soundar]

Hi,

Just check the below link,

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

this will give you some idea.

Regards,
Soundar.

 

[VIVEKMANE]

Thanks it works.........

Hi,

Just check the below link,

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

this will give you some idea.

Regards,
Soundar.

 

[VIVEKMANE]

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