View Single Post
  #1   Report Post  
Eldna
 
Posts: n/a
Default how to get rid of " " when copy values?

How can I get rid of " " around the value when I copy the value from one cell
to an other. I make the copy by selecting Past special and then Values. It
dosen´t write out " " in the cell but when looking at the value in a function
it writes " " around the value.

Ex; in the cell I can see 110000 but in the function I can see "110000".
It´s getting wrong when I´m using a function how compares two cells where the
first one say´s 110000 and the second one say´s "110000".