Target cell showing a ' after I Paste>Special>Value. Why?

T

TWT

I need some help with formatting the cells:

Description of steps:

1) I input a formula which returns a cell as blank if there are no values in
it.
E.g. =IF(D14<>"-",COUNTIF(Data!R:R,D14),"")

2) When the cell is returned as blank, I copy this cell and do a
Paste>Special>Values to a target cell.

Problem:

3) The target cell shows an apostrophy (i.e. a ') after i did the
Paste>Special>Value.

Question:
4) What must I do such that when I do a Paste>Special>Value, the target cell
returns a blank instead of a '?

Additional Note:
5) I did this on one of my colleagues' PC, and theirs didn't show a '. So I
suspect it's some settings, but we can't figure out which settings was
affected.

Many thanks in advance.
 
D

Dave Peterson

Check your other post.
I need some help with formatting the cells:

Description of steps:

1) I input a formula which returns a cell as blank if there are no values in
it.
E.g. =IF(D14<>"-",COUNTIF(Data!R:R,D14),"")

2) When the cell is returned as blank, I copy this cell and do a
Paste>Special>Values to a target cell.

Problem:

3) The target cell shows an apostrophy (i.e. a ') after i did the
Paste>Special>Value.

Question:
4) What must I do such that when I do a Paste>Special>Value, the target cell
returns a blank instead of a '?

Additional Note:
5) I did this on one of my colleagues' PC, and theirs didn't show a '. So I
suspect it's some settings, but we can't figure out which settings was
affected.

Many thanks in advance.
Click to expand...
 
Top