Forum Discussion
Unable to create a new Teams List from Excel using date formatted columns
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.
Creating 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).
5 Replies
Creating 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).
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
Sorry to hear that, but I can't help with this, did only couple of lists to test functionality.
