Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Worksheet Functions | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions |