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

how to get rid of " " when copy values?
 

Select the range of cells that you want to clean. Then pull-down:

Edit Find and enter the double quote character. In the replace field enter
nothing. The run find/replace . All the double quotes should vanish.
--
Gary''s Student


"Eldna" wrote:

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