Not sure I understand your question.

But what I use to do when Excel is putting zeros in cells that I want to
keep blank, is as follow:
(Keep in mind that I am using I Norwegian Excel program, so I have to
translate to English)

Right click the cell(s) you want to changes and select €œFormat cells€�. Go to
€œNumber€� (its where you choose what format your data should have in the
cell) and choose €œown definition€�. Wright €œ €œ (exclamation mark with space
between) if its text that appears as zero or just # if its numbers.

Have a nice day :)
ElFrodo


"pczerny" wrote:

Hi,

I'm trying to create a blank cell in excel 2003. When I move data from a
blank cell, excel turns the data from a blank cell into a zero and I'd like
it left as a blank cell so that a graph of the data shows a gap.

Thanks ahead of time.

--
Paul Czerny