Custom number format

**johnjohns** · 06-06-2010, 08:36 AM

Can somebody help me for a custom number format where I find the number in the following way

15,00,000

than

1,500,000

regards

johnjohns

**Andy Pope** · 06-06-2010, 08:46 AM

00","00","000

**johnjohns** · 06-07-2010, 12:52 AM

Thank you Andy. Sorry that I did not explain it clearly. My requirement is the Indian style of formatting. That is, counting from right, the first 3 digits to be separated with a coma, then the next two digits and the next two and so on.
1
15
150
1,500
15,000
1,50,000
15,25,000
1,52,35,500

regards

johnjohns

**Andy Pope** · 06-07-2010, 04:24 AM

Here is a number format and event code solution,

Commas in Indian style

**johnjohns** · 06-07-2010, 05:35 AM

So Andy, is this a possible one, without a macro support (I do not know if vba could support this either)?

rgds

johnjohns

**Andy Pope** · 06-07-2010, 05:54 AM

did you try the solutions offered in that thread?

**johnjohns** · 06-07-2010, 06:21 AM

So Sorry Andy. Now only I found and tried the link as I am not that used to this new format of the forum site. But thanks a million. I got my answer from the link. Thank you Andy.