Help required in Custom Number format

[Madhu]

Hi friends,

I have a number 1525149. When i apply "comma" style it gives 1,525,149.
Where as i need 15,25,149 (indian style). Tried to modify in
Format>Cells>Custom number format but not made it. Can you give a solution.

Thanks in advance.

Madhu

 

[Bob Phillips]

Hi Madhu,

Here is a format that you can use

[>=10000000]##\,##\,##\,##0.00­;[>=100000]##\,##\,##0.00;##,#­#0.00

 

[Guest]

This format works. If I wanted to put in a brackets in negative. How should I
do>
Can you help me.
--
With warm regards,

Shri

Hi Madhu,

Here is a format that you can use

[>=10000000]##\,##\,##\,##0.00­;[>=100000]##\,##\,##0.00;##,#­#0.00



--
HTH

Bob Phillips

Hi friends,

I have a number 1525149. When i apply "comma" style it gives 1,525,149.
Where as i need 15,25,149 (indian style). Tried to modify in
Format>Cells>Custom number format but not made it. Can you give a solution.

Thanks in advance.

Madhu