Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using a CSV to import data.

The column of data has different and sometimes multiple numbers in one field.
For example...

2924,2925, 2926 in one field
2927,2928, 2929 in another field.

I have been using the format feature to save it as 'Text' and then importing.
The problem is when I reopen the CSV, it is not formatted as 'Text' anymore and all my numbers are mangled.

Any idea how to keep that column formatted as Text when re-opening the CSV?

share|improve this question
add comment

1 Answer

Open it through the Data \ Get External Data \ From Text tool, where you can specify the data type of columns.

There is a full description of the process on the Office website. If you prefer pictures, you can check out this site instead.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.