Displaying zeros in cells

Joined
Feb 3, 2020
Messages
19
Reaction score
9
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
 
Joined
Feb 3, 2020
Messages
19
Reaction score
9
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