Microsoft Excel maintain formatting when importing

Question

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?

Answer 1

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.