Forum Discussion
Export an excel table with date columns to a sharepoint list
Hi people. I would like to export an excel table to a sharepoint list, but I am not able to get the same date format in every column of the sharepoint list. As it is possible to see in the attached images, the date format in excel table is the same for all the cells, but when the table is exported to sharepoint they changed into different formats.
SharepointExcel
Does anybody know how to achieve the same format for all the columns in the sharepoint list?
Thank you in advance.
Just try to find and replace the ".19" to ".2019" then "." to "/"
Hope this working for you 🙂
3 Replies
Alireza Rahimifarid it sounds as a good method, but they are a lot of cells and the only possible way to get the date in this format (with /) is manually. I have tried to change the format, but I could not found the / format. Is there any other automatic way to get this format?
Just try to find and replace the ".19" to ".2019" then "." to "/"
Hope this working for you 🙂
