Forum Discussion
Solved
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 i...
Just try to find and replace the ".19" to ".2019" then "." to "/"
Hope this working for you 🙂
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 🙂