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
|