Data type auto convert
 

How can i change the type of a column with numbers store as number type to
text type and update the cells content without having to click on every
single cell ?

Data type auto convert
 

Let's say you have a column of numbers in column A. In an un-used column
enter:

=CHAR(39) & A1

and copy down. Then select the new column and do a copy.
Then select A1 and do a paste/special value.


This will convert your original column of numbers into a column of text
values.
--
Gary''s Student


"sickmind" wrote:

How can i change the type of a column with numbers store as number type to
text type and update the cells content without having to click on every
single cell ?