Forum Discussion
Custom Number Cell Style – 100s and billions
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 d...
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
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+!