View Single Post
 
Old 04-16-2019, 06:00 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

You get not dates, but datestring texts. The reason is, that the date format in your windows regional settings is different from format used in web page (in web page the format is "dd/mm/yyyy" - I don't know is it US or UK format, but it is sure in your computer it must be different. E.g. for me the short date format is "dd.mm.yyyy", and I see the 1st date in column A (the date you obviously reentered) in this format. All other dates are for me strings.

I could easily convert all those strings to dates - I selected the column A, and replaced all "/" with "." (i.e. with my date delimiter).
Reply With Quote