Oct 28 2019 01:45 AM
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.
Does anybody know how to achieve the same format for all the columns in the sharepoint list?
Thank you in advance.
Oct 28 2019 04:51 PM
Oct 29 2019 05:45 AM
@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?
Oct 29 2019 08:20 AM
SolutionJust try to find and replace the ".19" to ".2019" then "." to "/"
Hope this working for you :)
Oct 29 2019 08:20 AM
SolutionJust try to find and replace the ".19" to ".2019" then "." to "/"
Hope this working for you :)