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
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.
##\,##\,##\,##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. 🙂
- Hi Subodh,
I do not see where to put proposed solution as a Best Response. Please guide me and I will be happy to do that. Thanks.I haven't asked any questions in the forum so far therefore not aware of how to do this but maybe HansVogelaar would guide you to do that.
