Removing 0 from cell that is blank

[Mike]

I am have set-up a worbook in which one worksheet is populated by by data
completed within another worksheet. The problem I have is that if a cell is
left blank, not filled in by a number or text, it is left with a zero (0).
How do I have this removed from my worksheet when data is not completed?

Thanks
Mike

 

[Gary''s Student]

instead of:
=Sheet2!A1
use something like:
=IF(Sheet2!A1="","",Sheet2!A1)

 

[Mike]

Thanks. I just tried doing that and it gave me a "Flase" error.

 

[Dave Peterson]

Time to post the formula you used--or try GS's suggestion once more.

Or did the "sending" cell really contain False/Flase???

 

[Mike]

Here is the formula I used which is giving me the "false" error. Thank you.

=IF('Start-up'!C9:J9=",",'Start-up'!C9:J9)

 

[Reeza]

Here is the formula I used which is giving me the "false" error. Thank you.

=IF('Start-up'!C9:J9=",",'Start-up'!C9:J9)







- Show quoted text -

Need the double quotes, excel doesn't work with single quotes
=IF('Start-up'!C9:J9="","",'Start-up'!C9:J9)

 

[Dave Peterson]

You're going to need a formula for each cell:

=IF('Start-up'!C9="","",'Start-up'!C9)

And watch those commas and double quotes!