Copy from merge cell

[Guest]

When I copy (Cell B2) from a merge cell for example A1 to S1 the result is
#########
When I delete the range and copy from A1 it work, but when merge cell (A1 to
S1) is blank "0" appear is B2.
How to get rid of the "O"

 

[Dave Peterson]

Try formatting that receiving cell (B2?) as General.

Cells formatted as Text have problems when the length of the string is between
255 and 1024.

 

[Guest]

Try formatting that receiving cell (B2?) as General.

Cells formatted as Text have problems when the length of the string is between
255 and 1024.

MK wrote:

Dave it doesn't work, the "0" still appear. Thanks for your help anyway.
Anyone out there can help?
Thanks for your help in advance.....MK

 

[Dave Peterson]

Are you copying and pasting or are you using a formula that returns the value in
A1?

If your formula looks like:

=a1
make it look more like:
=if(a1="","",a1)

I'm kind of confused at what you're doing.

If you don't get a better response, you may want to rephrase your question.

 

[Guest]

Yes got it, thank you very much

Are you copying and pasting or are you using a formula that returns the value in
A1?

If your formula looks like:

=a1
make it look more like:
=if(a1="","",a1)

I'm kind of confused at what you're doing.

If you don't get a better response, you may want to rephrase your question.