Linked cells show

Microsoft Office excel 2007 home & stude...
December 30, 2010 at 16:20:30
Specs: Macintosh 10.6.5, 2.8 GHz Intel Core 2 Duo
In Excel I'm linking a row of cells to elsewhere on the same sheet. Is there anyway to eliminate the "0" that appears when linking to a blank cell??

See More: Linked cells show

Report •


#1
December 30, 2010 at 17:31:29
Try

=IF(A1=0,"",A1)

MIKE

http://www.skeptic.com/


Report •

#2
December 30, 2010 at 18:59:37
Mike,

It worked!!!

Many thanks from a Excel beginner.

Alan


Report •

#3
December 30, 2010 at 19:04:23
Glad I could help.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question