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
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.