Sometimes Excel automatically formats strings that look like dates as dates. For example a code 10-21-21 reformats as Oct 21. Or a Project April25 could be seen as Apr 25
This is why it is important to open CSV files in Excel using this method:
1. Start from a blank worksheet
2. In the Data tab select "From Text/CSV"
3. If the preview looks right, then press "load"
Because Excel can reformat cells in unexpected places, this method should be used at all times.
Comments
0 comments
Please sign in to leave a comment.