Blank result cell instead of zero

In Excel 2003, I have identical formulae in defferent worksheets. In one
worksheet if there is no result, it shows a zero. In the other worksheet,
the cell is blank. I think there is a switch someplace to show zero or blank
but I don't know where it is. How can I make that choice? I don't
understand how the two different worksheets got set different. 1 was a copy
of the other...does that have something to do with it?

Thanks,
--
Rich D
Armstrong Custom Homes
Redmond

Sorry 'bout that...thought I was in Excel

"Rich D" wrote:

In Excel 2003, I have identical formulae in defferent worksheets. In one
worksheet if there is no result, it shows a zero. In the other worksheet,
the cell is blank. I think there is a switch someplace to show zero or blank
but I don't know where it is. How can I make that choice? I don't
understand how the two different worksheets got set different. 1 was a copy
of the other...does that have something to do with it?

Thanks,
--
Rich D
Armstrong Custom Homes
Redmond

First off, this newsgroup is dedicated to MS Access, a database program, no
MS Excel.

Secondly, you really should try using your apps Help before posting on any
newsgroup. Simply enterering "Zero" in Excel Help will bring up:

On the Tools menu, click Options, and then click the View tab. Do one of the
following:

To display zero (0) values in cells, check the Zero values check box.

To display a blank cell, uncheck the box

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200812/1