Forum Discussion
Solved
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
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.
