Mar 22 2021 02:59 AM - edited Mar 22 2021 03:57 AM
Hello Everyone,
I would to add the below comma separation format in the numeric value.
Presently I have 1,000,000,000.00
But I would like to add 100,00,00,000.00 in this format...???
OR
What should i write in Format Cells -
Please help...??
Mar 22 2021 05:00 AM
If you want to use the Indian Numbering System, you must select the corresponding digit grouping setting 12,34,56,789 in the Currency and Number tabs of Customize Format (press Windows key+R, type control intl.cpl and press Enter or click OK, then click Additional settings...)
1000000000 will then be displayed as 1,00,00,00,000.00
As far as I know, there is no way to make Excel format it as 100,00,00,000.00
Mar 22 2021 05:01 AM
Mar 22 2021 06:13 AM
Cell formatting
Custom
Type: insert -> ### "." ## "," ## "," ### "." ##
Format Cell:
###"."##","##","###"."##
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Mar 22 2021 06:22 AM
Mar 22 2021 06:47 AM
Mar 22 2021 06:55 AM
It's a nice trick, but such formats have the disadvantage that they don't work well for all numbers:
Mar 22 2021 07:15 AM
Mar 22 2021 07:27 AM
Good point!
[<100000]#,##0.00;[<10000000]#\,##\,##0.00;###\,##\,##0.00
will deal with smaller numbers but then the number formats would need to be combined with conditional formatting to accommodate very large numbers.
Mar 22 2021 07:42 AM
Mar 22 2021 07:43 AM
Mar 22 2021 08:23 AM