3d reference
 

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

3d reference
 

You could use a custom number format or even Format|conditional formatting.

But those will hide the cells that are returning an actual 0.

I'd do that extra work:

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

=====
You could use a custom number format like:
General;-General;;
(Positive;negative;zero;text)

Or a custom format
cell value is equal to 0
and use the same font color as fill color.


jbc49 wrote:

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

--

Dave Peterson

3d reference
 

EXCEL 2007

Office Button

Excel Options

Advanced

Display option for this worksheet (on right hand side)

Select / de-select Show a zero in cells that have zero value

If my comments have helped please hit Yes.

Thanks.






"Dave Peterson" wrote:

You could use a custom number format or even Format|conditional formatting.

But those will hide the cells that are returning an actual 0.

I'd do that extra work:

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

=====
You could use a custom number format like:
General;-General;;
(Positive;negative;zero;text)

Or a custom format
cell value is equal to 0
and use the same font color as fill color.


jbc49 wrote:

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

--

Dave Peterson
.

3d reference
 

Sorry, my previous posting was between 2 different Workbooks.

Between 2 different Worsheets of same Worbook try:-

=IF(Sheet1!A1="","",Sheet1!A1)

If Sheet 1 cell A 1 contains data that will be returned in Sheet 2 cell A1.

If Sheet 1 cell A1 is blank blank will be returned in Sheet 2 cell A1.

If my comments have helped please hit Yes.

Thanks.



"jbc49" wrote:

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

3d reference
 

EXCEL 2007

I reckon this work as:-

=IF(Sheet99!A1="","",Sheet99!A1)



"Dave Peterson" wrote:

You could use a custom number format or even Format|conditional formatting.

But those will hide the cells that are returning an actual 0.

I'd do that extra work:

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

=====
You could use a custom number format like:
General;-General;;
(Positive;negative;zero;text)

Or a custom format
cell value is equal to 0
and use the same font color as fill color.


jbc49 wrote:

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

--

Dave Peterson
.

3d reference
 

I had a space in the worksheet name.

trip_to_tokyo wrote:

EXCEL 2007

I reckon this work as:-

=IF(Sheet99!A1="","",Sheet99!A1)

"Dave Peterson" wrote:

You could use a custom number format or even Format|conditional formatting.

But those will hide the cells that are returning an actual 0.

I'd do that extra work:

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

=====
You could use a custom number format like:
General;-General;;
(Positive;negative;zero;text)

Or a custom format
cell value is equal to 0
and use the same font color as fill color.


jbc49 wrote:

Is it possible to suppress the "0" that is returned when referencing a blank
cell in another worksheet? I have used an IF function to ensure blank cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.

--

Dave Peterson
.


--

Dave Peterson

3d reference
 

Well, you didn't tell us which "various cell formats" you tried.
Was one of them "General;-General;" ?
--
David Biddulph


"jbc49" wrote in message
...
Is it possible to suppress the "0" that is returned when referencing a
blank
cell in another worksheet? I have used an IF function to ensure blank
cells
in the past, but that requires a good bit of labor for even a medium sized
worksheet. I tried various cell formats, but continue to get "0"s in the
linked cell.