SOLVED

New Contributor

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

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

11 Replies

# Re: How to write number in Excel in the format 99,99,99,999.99

If you are on Windows:

• Press Window key+R
• Type intl.cpl and press Enter or click OK.
• 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.

# Re: How to write number in Excel in the format 99,99,99,999.99

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.

# Re: How to write number in Excel in the format 99,99,99,999.99

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

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

best response confirmed by KA10900gmail (New Contributor)
Solution

# Re: How to write number in Excel in the format 99,99,99,999.99

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

# Re: How to write number in Excel in the format 99,99,99,999.99

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

# Re: How to write number in Excel in the format 99,99,99,999.99

Use this option.

# Re: How to write number in Excel in the format 99,99,99,999.99

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

# Re: How to write number in Excel in the format 99,99,99,999.99

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.

# Re: How to write number in Excel in the format 99,99,99,999.99

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.

# Re: How to write number in Excel in the format 99,99,99,999.99

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.

# Re: How to write number in Excel in the format 99,99,99,999.99

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.