Could be a settings issue.

There is an option to disply or not display zero values.

Might be the other Excel workbook has display zero values unchecked.

In 2003........Tools<OptionsViewWindow Options.

In 2007........ButtonExcel OptionsAdvancedDisplay options for this
worksheet.


Gord Dibben MS Excel MVP


On Wed, 3 Feb 2010 12:07:01 -0800, TommyD
wrote:

Thanks for your answer… but the strange thing is that I have an other excel
spreadsheet where this phenomena doesn’t occur so I thought it could have
something to do with settings?

/Tommy

"Fred Smith" wrote:

"Why isn't B1 empty if A1 is?" is the same as "Why does the sun rise in the
east?" That's just the way it is.

Modify your formula to:
=if(a1="","",a1)

Regards,
Fred

"TommyD" wrote in message
...
Hi,

I have a cell reference in cell B1 (=A1).

If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is?

Both cells have format General.


/Tommy


.