How to Alter a Column Type
Microsoft Excel allows you to change the types of data stored within a record's columns. Altering this type configuration allows you to fine tune the types of information that you allow into your data sheet. This can be essential in preventing errors in parsing or exporting spreadsheets into another program at a later time.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Excel and open the spreadsheet you want to work with.
-
2
Right-click a column within your data sheet and then select "Column" from the pop-out menu.
-
-
3
Select "Convert" and then "Data Type To."
-
4
Select the data type to allow in your column such as "Text" or "General."
-
1
