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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies