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

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 11, 2014 at 05:20 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 11, 2014 at 06:08 PM
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

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,833
Mar 11, 2014 at 05:29 PM
I would think you right click on the cell and select format.
0
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 2
Mar 11, 2014 at 06:08 PM
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
0