Custom Number Cell Style – 100s and billions

Occasional Contributor

Hi everyone.


I am currently using this custom number cellstyle so that my figures can display with commas.




It works perfectly for:





But it displays a comma in front of the numbers below 1,000






and of course it does not work for 1000,000 and higher.

Any input or a cellstyle custom number format will be very much appreciated


Thanks for reading :-)

5 Replies
Delete the backslash (\) from your custom number format.

Thanks for response @Twifoo 


If I remove the (\) from the custom number format it leaves a space and removes the comma even though there is a comma in the custom number format.


The number displays like this 1 222 555 – instead of 1,222,555

You may refer here for additional information:

Thanks for your help, I have been there before and they also show the same custom number format


Which does not work – the only one that works is the one with the (/) in it.

Try formatting your numbers with this shortcut:
Related Conversations
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Share with : Custom Group
anonymous-user in Microsoft Stream Forum on
3 Replies
Pricing & customization
anonymous-user in Microsoft Stream Forum on
2 Replies
Custom profile: hide known file extensions
PatrickF11 in Microsoft Intune on
1 Replies