Excel Help - Why does a 0 appear when copying cells between worksheets?

[optimus_1]

Hi

I was wondering why a 0 appears when copying blank cells into another worksheet?.

Also how do you stop this if you are copying a larger block of text and
some of the cells within this are blank and they appear as 0 when i would like them to appear as a blank also?.

Regards
Nathan

 

[Indigo]

Are you using "=" when doing this? i.e. "=Sheet1!A1" If so, you might try using "IF"
in your statement. For example: =IF(Sheet1!A1 <>"",Sheet1!A1, "")

HTH

 

[Brianwarnock]

This happens within sheets as well as across them.

As to why, well at a guess I would say that as EXCEL is designed to handle calculations and empty cells cause problems to formulae then it is trying to minimise that.

Although Blank cells, as opposed to empty ones, also cause problems they are copied as Blank, I assume it thinks you know what you are doing if you have entered a Blank.

Brian

 

[optimus_1]

Thanks for the assistance

Greatly appreciated