0

I have excel file with columns formatted to dates as below: enter image description here

When I tried to import data to Team as list I get below issue:

enter image description here

Can someone explain how to fix this ?

EDIT:

I did import the excell file to Team during List creation :

enter image description here

enter image description here

enter image description here

Edit 2

Oh ok i see it now , during import you have to convert data :), thanks!!

enter image description here

Wiktor
  • 115
  • 5
  • 1
    No, that value is correct (technically). It’s the number of days since December 30, 1899. // You do not mention how you “import” the data (copy/paste?) or where in Teams in even ends up. In a chat or channel? Or maybe some widget or embedded app? – Daniel B Jul 07 '22 at 09:09
  • Hi Daniel , Edited my post with method to import data – Wiktor Jul 07 '22 at 09:17
  • 1
    What kind of file format are you trying to import? Follow the steps to create the list first: https://support.microsoft.com/en-us/office/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa – Lee Jul 07 '22 at 09:31
  • ok i see it now, you have to convert during import :) thank you – Wiktor Jul 07 '22 at 09:37
  • Please do not [edit] the answer into the question. You should write a separate answer. – DavidPostill Jul 07 '22 at 12:59

0 Answers0