Help required in Custom Number format

  • Thread starter Thread starter Madhu
  • Start date Start date
M

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
 
Hi Madhu,

Here is a format that you can use

[>=10000000]##\,##\,##\,##0.00­;[>=100000]##\,##\,##0.00;##,#­#0.00
 
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


Bob Phillips said:
Hi Madhu,

Here is a format that you can use

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



--
HTH

Bob Phillips

Madhu said:
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
Click to expand...
Click to expand...
 
Back
Top