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
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.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. 🙂
Yes, I agree. The format is good for the sample number only.
