| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
| get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
| How do I convert some data in the row to columns? | Excel Discussion (Misc queries) | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
