Nan -
You have it correct (almost). You just need to go one step further.
You need to click each field (column) that is being converted and choose text. See the image attached Two fields are still "General" and will be treated as numbers.
An alternative method rather than clicking each column individually would be to click in the first column in the data preview - scroll over to the last column using the scroll bar at the bottom then hold down the 'shift' key and click in the last column. Now chose the text radio button and all the columns will be assigned the text data type.
Hope that helps!
Scott
Last edited by ScottA; 05-03-2014 at 05:35 AM.
|