There is unfortunately no function that returns a blank. We would like to
have something like BLANK() or NULL(), but it's not available.

=IF(LEN(A1)=0,NA(),A1)

LEN(A1) checks for a blank. If there is a blank, NA() turns into #N/A in the
chart, which isn't exactly a blank: no point is drawn in a line or XY chart
for this cell, and any line connecting data points connects the points on
either side.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"pczerny" wrote in message
...
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