3,888 questions
I think that you should not use 0;; if the cells contain negative numbers that must not be hidden. Use 0;-0; in this case.
New format code for hide zero in excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
it says use code ***0;-0;;@ *** can hide zero in below link , but i find new format code, you just write 0;; , it also can hide Zero in the cell
please comments if i am right or not .
Microsoft 365 and Office Excel For business Windows
Accepted answer
-
Viorel 122.6K Reputation points2023-07-03T08:22:59.0633333+00:00 -
Anonymous
2023-07-03T08:26:28.9866667+00:00 Perfect , thanks , yes , if 0;; will disappear negative value
-
Anonymous
2023-07-03T08:33:05.7333333+00:00 one more thing , the official says use 0;-0;;@
so what is the different __0;-0;;@ and __0;-0; , could you kindly help me to make more clear , thanks
-
Viorel 122.6K Reputation points
2023-07-03T08:53:02.4633333+00:00 The last fourth portion is used to format the cells that contain text instead of numbers:
See the “Text and spacing” section. “@” means the text. The
0;-0;or0;-0;;@format will show the text. The0;-0;;will hide the text. The0;-0;;[Blue]@will show the text using blue colour. -
Anonymous
2023-07-04T06:08:50.6+00:00 yes , i learn something today by the link you shared , it is very useful , and you also explain very clear , thanks for your help , you are very nice ,
Sign in to comment -