Feb 19 2019 04:39 AM
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 :)
Feb 19 2019 05:22 AM
Feb 19 2019 10:35 AM
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
Feb 19 2019 10:51 AM
Feb 19 2019 11:06 AM
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.
Feb 19 2019 11:12 PM