Forum Discussion
Unable to create a new Teams List from Excel using date formatted 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).
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.
- SergeiBaklan
I really appreciate your pointing out the place to change the formatting. Web documentation doesn't go as far as you did.LaurieBeamish , glad to help, good luck with Lists!