Forum Discussion
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
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
11 Replies
You may apply the following Custom Number Formatting to show your number in the desired format.
##\,##\,##\,##0
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
- 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.
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.
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.
Have you tried the method that I showed? It should do exactly what you want.
