Dec 02 2020 11:44 AM
When creating a Teams List from an Excel spreadsheet that contains columns with date formats, the columns with dates are converted to their numeric value and there is no way to adjust the column format to Date and Time format.
This occurs with multiple users, both desktop and web clients. We do have ability to create from scratch new lists with date columns.
Dec 03 2020 04:18 AM
SolutionCreating list from Excel file in Lists app, both in Teams and in O365, you have an option to change the type of the column.
If you missed that when dates will be shown as numbers.
Dates format here as for Sharepoint site (Teams) or as in your O365 profile (Lists app).
Dec 03 2020 07:08 AM
Thanks Sergei. That was somewhat invisible to me until you pointed that out. That got me one step further but have run into another issue. When I change the number to Date and Time I now get a new error:
I went back into the Excel spreadsheet and changed the dates to the ##/##/## #:## PM format. Saved the file and tried again and got the same error. I then went back into the Excel and changed the Format to Custom m/d/yyyy h:mm AM/PM since the requested format was not available. That worked with one column but when I tried with other date columns got the error again. Very kluge
Dec 03 2020 10:00 AM
Sorry to hear that, but I can't help with this, did only couple of lists to test functionality.
Dec 03 2020 11:10 AM
Dec 03 2020 12:10 PM
@LaurieBeamish , glad to help, good luck with Lists!
Dec 03 2020 04:18 AM
SolutionCreating list from Excel file in Lists app, both in Teams and in O365, you have an option to change the type of the column.
If you missed that when dates will be shown as numbers.
Dates format here as for Sharepoint site (Teams) or as in your O365 profile (Lists app).