Problem I've never had before.

When I reference another cell with =Y392 for example.

If there is no value in Y392 it fills the cell with 0.

I have other sheets that I've used this referencing in and that doesn't happen the cell remains blank.

Here's a snapshot.

Excell.png

Probably an easier way

Hi,

There is possibly an easier way to do this but if you put in an if function then you can get rid of the zero value as follows:

=IF(Y392="","",Y392)

In Excel Quotation marks without any characters between them represent Blank, therefore with the above statement you are saying if Y392 is blank/empty then leave this cell blank, otherwise populate with the value in Y392.

Hope this helps

Mark