3d reference

J

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.
 
D

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.
 
T

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.
 
T

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.
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top