Cell formating:Select the Number tab

[IndianGuru]

How do I format a cell such that I see a number say 40000000.00 as 4,00,00,000.00 ?

[Philip Reece-Heal]

Click Format then Cells. Select the Number tab.
Click on Custom in the category box and in the Type box type #,###.00



"IndianGuru" <IndianGuru.1vngya_1127207106.465@excelforum-nospam.com> wrote
in message news:IndianGuru.1vngya_1127207106.465@excelforum-nospam.com...
>
> How do I format a cell such that I see a number say 40000000.00 as
> 4,00,00,000.00 ?
>
>
> --
> IndianGuru
> ------------------------------------------------------------------------
> IndianGuru's Profile:
> http://www.excelforum.com/member.php...o&userid=27382
> View this thread: http://www.excelforum.com/showthread...hreadid=469097
>

[IndianGuru]

This does not work. I need to format my number as follows - 2,55,000.00 and not as 255,000.00

Can you help?

Click Format then Cells. Select the Number tab.
Click on Custom in the category box and in the Type box type #,###.00

> How do I format a cell such that I see a number say 40000000.00 as
> 4,00,00,000.00 ?