Depending on the original data source, date fields in excel may be imported with “text” field formatting (despite the user having attempted to format them as “date” fields) causing errors during the import process
What do you need to do:
- Update the date column to the format required for import
- Force a refresh of all data in the column
What’s the best way to do it:
- Right click the date column header and select “Format Cells”
- Select “Date” and the mm/dd/yyyy format highlighted below
- Then, select the column header and click the “Text to Columns” option in the Data tools
- Select “Delimited” and click Next
- Deselect/Uncheck all Delimiter options, and click Next
- The data in all cells in the column will now refresh, and the dates will appear as needed and import normally