How to write number in Excel in the format 99,99,99,999.99

[KA10900gmail]

How do I write number in Excel in the format 99,99,99,999.99

[#2]

@KA10900gmail 

If you are on Windows:

• Press Window key+R
• Type intl.cpl and press Enter or click OK.
• Click Additional settings...
• Select 12,34,56,789 from the Digit grouping drop-down.
• Click OK.

In Excel:

• Select the cells that you want to format.
• Press Ctrl+1.
• Activate the Number tab.
• Select Number.
• Set Decimal places to 2.
• Tick the check box Use 1000 separator (,).
• Click OK.

[#3]

@Hans Vogelaar 

Hi Hans, My issue relates to Excel. In an excel cell or row or column, I would like the number to show as 

99,99,99,999.00  This typical way of writing numbers is followed in India.

99,99,99,999.00  would be read as 99 Crore, 99 Lakhs, 99 Thousand, 999

I would like to format the number in Excel to place comas as I have shown above. Please let me know if there is a way to do that in Excel. 

Thanks for your interest. 

[#4]

@KA10900gmail 

You may apply the following Custom Number Formatting to show your number in the desired format.

##\,##\,##\,##0

[#5 · Accepted solution]

@Subodh_Tiwari_sktneer 

The disadvantage of the custom number format ##\,##\,##\,##0 is that small numbers will have extra commas. For example, 12345 will be displayed as ,,12,345

[#6]

@KA10900gmail 

Have you tried the method that I showed? It should do exactly what you want.

[#7]

@KA10900gmail 

Use this option. 

[#8]

@Hans Vogelaar 

Yes, I agree. The format is good for the sample number only.

[#9]

Thanks Subodh. You are right. I made the following modification to show 2 places after the decimal.
##\,##\,##\,##0.00

This question can now be closed.

[#10]

You're welcome @KA10900gmail! Glad it worked as desired.

Btw, you didn't accept the post with the proposed solution as a Best Response.

Please take a minute to accept the correct post with the proposed solution as a Best Response. :)

[#11]

Hi Subodh,
I do not see where to put proposed solution as a Best Response. Please guide me and I will be happy to do that. Thanks.

[#12]

@KA10900gmail 

I haven't asked any questions in the forum so far therefore not aware of how to do this but maybe @Hans Vogelaar would guide you to do that.