Excel won't show zero in cell?!

[IRSteve]

I've had this happen on a few sheets in some of my excel workbooks. Basically if I enter or have a formula that needs to show a 0 (zero), the cell comes up blank.

I've tried changing the Number category/format to no avail.

Anyone know how to fix this?

thanks!

 

[GlennUK]

Depending on what version of Excel you have, you could check the settings in Tools/Options/View and make sure that the Zero Values checkbox is ticked.

 

[IRSteve]

ahh, that was it!

is there a reason why some sheets in a workbook would have that disabled and others would have it enabled?

how would it get disabled anyway?

thanks!!

 

[IRSteve]

wait, now it shows 0 instead of blank text for formulas that should show blank text...

 

[GlennUK]

wait, now it shows 0 instead of blank text for formulas that should show blank text...

Show the formula causing the problem.

 

[IRSteve]

I fixed it using an if statement and ISBLANK. it was a for an array look up.

sorry to have bothered you with that. thanks for the help!

 

[GlennUK]

Glad you've got it working.