Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
108
Views
Topic starter
I'm exporting header information from DrillingInfo Excel. When I do this well number column turns into date, if I try to make it a number it gives me for example 45265 number. Can someone help me to see the best way to open the CSV file in Excel so it won't do this thanks.
Posted : 10/05/2023 11:45 am
Best is to import the CSV, either via Power Query or the legacy text wizard. to avoid issues as you describe, do not open a CSV file directly in Excel.
Importing allows you to explicitly tell Excel what each column of data represents (a text, a number or a date for instance). By just opening a CSV you let Excel second guess what it is dealing with. It often goes OK but sometimes Excel get's it all wrong.
Posted : 11/05/2023 12:09 am
