Apr 27 2022 09:10 PM
Apr 27 2022 10:02 PMSolution
@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.