Aug 05 2021 08:50 AM
How do I write number in Excel in the format 99,99,99,999.99
Aug 05 2021 11:07 AM - edited Aug 05 2021 11:07 AM
If you are on Windows:
In Excel:
Aug 10 2021 03:09 PM
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.
Aug 10 2021 09:58 PM - edited Aug 10 2021 09:59 PM
You may apply the following Custom Number Formatting to show your number in the desired format.
##\,##\,##\,##0
Aug 11 2021 03:03 AM
SolutionThe disadvantage of the custom number format ##\,##\,##\,##0 is that small numbers will have extra commas. For example, 12345 will be displayed as ,,12,345
Aug 11 2021 03:05 AM
Have you tried the method that I showed? It should do exactly what you want.
Aug 11 2021 03:39 AM - edited Aug 11 2021 03:40 AM
Aug 11 2021 05:14 AM
Yes, I agree. The format is good for the sample number only.
Aug 11 2021 08:55 AM
Aug 11 2021 09:59 AM
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. :)
Aug 11 2021 03:13 PM
Aug 11 2021 07:40 PM
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.
Aug 11 2021 03:03 AM
SolutionThe disadvantage of the custom number format ##\,##\,##\,##0 is that small numbers will have extra commas. For example, 12345 will be displayed as ,,12,345