Custom Number Cell Style – 100s and billions

Copper Contributor

Hi everyone.

 

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

 

#\,##0;(#\,##0);”–“

 

It works perfectly for:

100,000

50,000

5,000

 

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

EG: 

,500

,20

,2

 

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:
https://exceljet.net/custom-number-formats

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

#,##0

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

Try formatting your numbers with this shortcut:
Ctrl+Shift+!