3d reference

[jbc49]

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]

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.

 

[trip_to_tokyo]

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.

 

[trip_to_tokyo]

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.

 

[trip_to_tokyo]

EXCEL 2007

I reckon this work as:-

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

 

[Dave Peterson]

I had a space in the worksheet name.

EXCEL 2007

I reckon this work as:-

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

 

[David Biddulph]

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