Custom Number Cell Style – 100s and billions

Question

Hi everyone.&nbsp;I am currently using this custom number cellstyle so that my figures can display with commas.&nbsp;#\,##0;(#\,##0);”–“&nbsp;It works perfectly for:100,00050,0005,000&nbsp;But it displays a comma in front of the numbers below 1,000EG:&nbsp;,500,20,2&nbsp;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&nbsp;Thanks for reading :-)

twifoo · Answer

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

twifoo · Answer

You may refer here for additional information:https://exceljet.net/custom-number-formats

sofia-cyan · Answer

Thanks for response&nbsp;Twifoo&nbsp;&nbsp;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.&nbsp;The number displays like this 1 222 555 – instead of 1,222,555

sofia-cyan · Answer

Thanks for your help, I have been there before and they also show the same custom number format#,##0Which does not work – the only one that works is the one with the (/) in it.

twifoo · Answer

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

Forum Discussion

Custom Number Cell Style – 100s and billions

5 Replies

Resources