Forum Discussion

JaniceTIS05775's avatar
JaniceTIS05775
Copper Contributor
Apr 28, 2022

Excel turning numbers into dates

I import a .csv file that automatically changes 

4840-1/2

to

2/01/4840

 

How can I stop this happening?  I re enter it every time but it must be something I can fix??

 

Thanks

 

Excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 28, 2022

    JaniceTIS05775 I suspect you "import" the civ by double-clicking on it. Then, Excel tries to be a bit too smart at times and automatically transforms text into dates if the particular text only slightly resembles a date.

     

    From the Data ribbon, use Get Data, From CSV/Text or From Text (Legacy). That will allow you to set the correct data type for each column. 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 28, 2022

    JaniceTIS05775 I suspect you "import" the civ by double-clicking on it. Then, Excel tries to be a bit too smart at times and automatically transforms text into dates if the particular text only slightly resembles a date.

     

    From the Data ribbon, use Get Data, From CSV/Text or From Text (Legacy). That will allow you to set the correct data type for each column. 

Resources