Take out the ceros of specific cells, not the whole worksheet

[Closed]
Report
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
how could I make the 0 ceros of an empty cell not to appear? I've tried going into customs and entering £#.##.00, which I got from somewhere though don't understand its logic very well, but it doesn't do anything to the cell. I know how to take the ceros off for the whole of the worksheet from options but not for specific cells. Also would like to know how to do the opposite, how to show ceros on specific cells. Thanks lot

2 replies

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,898
I would think you right click on the cell and select format.
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Yes, understand that. You go to format and choose number. But I need some columns to show the ceros when empty, so I when to options and ticked "show zeros", which make zero cells as a default. But I would like to know how to actually make the cero appear as a default, or not to appear only in specific cells. Sorry if the question is not very clear