Data type auto convert

S

sickmind

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 ?
 
G

Gary''s Student

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