Forum Discussion
KA10900gmail
Aug 05, 2021Copper 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
- Aug 11, 2021
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
KA10900gmail
Aug 10, 2021Copper Contributor
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.
HansVogelaar
Aug 11, 2021MVP
Have you tried the method that I showed? It should do exactly what you want.