=Sheet1!A1 - with a blank entry!!!
 

Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on sheet2 - how can I have this so its left blank if no value is in
sheet1 a1??

=Sheet1!A1 - with a blank entry!!!
 

=if(Sheet1!A1 = "", "", Sheet1!A1)
--
HTH...

Jim Thomlinson


"CP" wrote:

Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on sheet2 - how can I have this so its left blank if no value is in
sheet1 a1??

=Sheet1!A1 - with a blank entry!!!
 

Thank you - that had become real annoying :)

"Jim Thomlinson" wrote:

=if(Sheet1!A1 = "", "", Sheet1!A1)
--
HTH...

Jim Thomlinson


"CP" wrote:

Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on sheet2 - how can I have this so its left blank if no value is in
sheet1 a1??