Displaying zeros in cells


Joined
Feb 3, 2020
Messages
13
Reaction score
6
Hello, I'm sure this is simple but I can't find out how to do this.

When I key in the number 0 (zero) I want 0 to show in the cell. I've inherited the spreadsheets from someone else and currently when I type 0 I get a dash. Looking at excel help I can find a section telling me how to fill every unused space with 0, but I don't need that - I just want it to happen when I key something in.

TIA
 
Ad

Advertisements

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,651
Reaction score
1,153

HTH
 
Ad

Advertisements

Joined
Feb 3, 2020
Messages
13
Reaction score
6
Aha, thanks muckshifter.

I must be more diligent with my searching in future.
I must be more diligent with my searching in future. ( I WILL write this out 20 times.... :) )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top