anyone else? how to get the blanks without changing formulas.

[Wei]

In my spreadsheet, I am trying to get data from another
Excel file.
eg. ='[2004 Distribution Survey Data_Final.xls]2. Expenses-
Cost Center'!$B$87

When the input file contains a blank cell, I am getting
a "0" intead of a blank. I would like to get a blank if
the cell has no data.

Is there an easy way to do this? I don't want to change
all my formulas to =If(isblank(...),"", ...)
There are too many formulas to change.

Thanks a lot for any help!

Wei

 

[Frank Kabel]

Hi
please stay in the original thread. As mentioned there: no feasible
solution without changing your formulas

 

[Myrna Larson]

Changing the formulas is what's required. Otherwise your option would be to
set up this sheet to not display zeroes at Tools/Options/View.

 

[Gord Dibben]

Wei

See mass formula-change code at one of your other posts.

Gord Dibben Excel MVP

 

[Ron Rosenfeld]

In my spreadsheet, I am trying to get data from another
Excel file.
eg. ='[2004 Distribution Survey Data_Final.xls]2. Expenses-
Cost Center'!$B$87

When the input file contains a blank cell, I am getting
a "0" intead of a blank. I would like to get a blank if
the cell has no data.

Is there an easy way to do this? I don't want to change
all my formulas to =If(isblank(...),"", ...)
There are too many formulas to change.

Thanks a lot for any help!

Wei

I could make some suggestions, but since this clearly represents something that
has another thread, and since you chose to start a new thread, I don't want to
waste my time suggesting solutions which you have already rejected.

In the future, it would benefit you to stay within the original thread.


--ron