How do I remove zeros from a linked blank cell?
 

When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet). How do I get them to display as
blank cells in the destination worksheet? I am using Excel 2003 SP3.

How do I remove zeros from a linked blank cell?
 

=if('sheet 99'!a1="","",'sheet 99'!a1)



Scott wrote:

When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet). How do I get them to display as
blank cells in the destination worksheet? I am using Excel 2003 SP3.

--

Dave Peterson

How do I remove zeros from a linked blank cell?
 

Is there a way to keep the formatting from the source spreadsheet? If I use
the If statement below, it wipes out the formatting (shading) from the
original cell.

"Dave Peterson" wrote:

=if('sheet 99'!a1="","",'sheet 99'!a1)



Scott wrote:

When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet). How do I get them to display as
blank cells in the destination worksheet? I am using Excel 2003 SP3.

--

Dave Peterson

How do I remove zeros from a linked blank cell?
 

Formulas don't return this kind of formatting. They return values.

You could copy|paste or have a macro do it.

Scott wrote:

Is there a way to keep the formatting from the source spreadsheet? If I use
the If statement below, it wipes out the formatting (shading) from the
original cell.

"Dave Peterson" wrote:

=if('sheet 99'!a1="","",'sheet 99'!a1)



Scott wrote:

When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet). How do I get them to display as
blank cells in the destination worksheet? I am using Excel 2003 SP3.

--

Dave Peterson


--

Dave Peterson