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"

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:

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

"Dave Peterson" wrote:

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

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

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.

MK wrote:

"Dave Peterson" wrote:

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

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


--

Dave Peterson

Yes got it, thank you very much

"Dave Peterson" wrote:

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.

MK wrote:

"Dave Peterson" wrote:

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

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


--

Dave Peterson