unwanted csv date conversion
 

I have a CSV file with the following information:
"Co","Profile","Profile Name"
"003","MAR4","MARK ROGERS - District or Corp Accountant"
"004","MAR4","MARK ROGERS - District or Corp Accountant"

Excel is automatically converting my TEXT MAR4 field to 4-Mar (3/4/2005).
The only way I can find to avoid the incorrect conversion, is to change the
extension to *.txt, then Import it, and on that column, change it from the
default type of "General" to "Text".

Is there some setting somewhere I can change so that it stops doing this
automatically?

Thank you,

Lori Gordon

That seems like a reasonable solution to me.

If you have to do this lots of times (and the data is always laid out the same
way), maybe you could record a macro when you open the .txt file with the
settings you like.

Then just rerun that macro (after changing the .csv name to .txt) when you need
to import the data again.

Lori Gordon wrote:

I have a CSV file with the following information:
"Co","Profile","Profile Name"
"003","MAR4","MARK ROGERS - District or Corp Accountant"
"004","MAR4","MARK ROGERS - District or Corp Accountant"

Excel is automatically converting my TEXT MAR4 field to 4-Mar (3/4/2005).
The only way I can find to avoid the incorrect conversion, is to change the
extension to *.txt, then Import it, and on that column, change it from the
default type of "General" to "Text".

Is there some setting somewhere I can change so that it stops doing this
automatically?

Thank you,

Lori Gordon

--

Dave Peterson