ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/188464-formula.html)

VIVEKMANE

Formula

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

Formula

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

VIVEKMANE

Formula

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

"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

VIVEKMANE

Formula

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

All times are GMT +1. The time now is 07:30 AM.