SOLVED

Export an excel table with date columns to a sharepoint list

Copper Contributor

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. 

SharepointSharepointExcelExcel

Does anybody know how to achieve the same format for all the columns in the sharepoint list?

 

Thank you in advance.  

3 Replies

@anova1992 

Try this format: 01/28/2019

 

4 digit for Year and use /

@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? 

best response confirmed by anova1992 (Copper Contributor)
Solution

@anova1992 

Just try to find and replace the ".19" to ".2019" then "." to "/"

Hope this working for you :)

 

 

 

 

1 best response

Accepted Solutions
best response confirmed by anova1992 (Copper Contributor)
Solution

@anova1992 

Just try to find and replace the ".19" to ".2019" then "." to "/"

Hope this working for you :)

 

 

 

 

View solution in original post