Formula in a field is represented by a zero.

[Michael J. Malinsky]

Tools>Options>View tab. Uncheck the Zero values checkbox. Anything with a
zero value should now be blank.

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[jdtivoli]

I have a workbook in which I have embedded many formulas.

I have successfully hidden the formulas using cell
protection.

However, all of the cells which have formulas in them
display a zero in the cell, unless the formula puts
something else there.

I would like for these cells to be blank unless they are
filled in as a result of the formula.

How can I get rid of all these zeros?

Jesse

 

[jdtivoli]

That works great!
Thank you.

Jesse

-----Original Message-----
Tools>Options>View tab. Uncheck the Zero values checkbox. Anything with a
zero value should now be blank.

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain




.