Text changes to Date in storing CSV

[dana]

Hi people,

I have a field that originally some of the values are numbers and some are text.

I used the Text function, and all of them are displayed in QV and in Excel as text.

After exporting to CSV, fields with values such as 01-01, 01-02, are displayed as 01-Jan, 01-Feb.

How can I resolve it?

Thanks!

[marcus_sommer]

It's an Excel feature. Don't open the csv with Excel else open it with an editor and copy & paste the content to Excel. Then use the divide-in-columns feature from the menu Data and within the third/fourth step you could define for each column how Excel should interpret the content.

[dana · Accepted solution]

I've added a space to the field ('  ' & FieldName) and it resolved the issue.

[seanbruton]

Superb, very helpful solution!!!