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

[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.

 

[DILipandey]

Hi,

please check if there is some formatting set in the cell where you finally
do the paste - special - value.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[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.