Displaying zeros in cells

[BigDeal]

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

 

[muckshifter]

Display or hide zero values - Microsoft Support

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

support.microsoft.com

HTH

 

[BigDeal]

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.... )