Menu
Ask a question Report

Incorrect date while saving csv format

- - Latest reply: ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 - Nov 12, 2018 at 04:58 PM
Excel Ask a question Report
Hello,

I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens it, the date gets changed. 1 Dec'18 to 31 Dec'18 is alright but 1 Jan'19 to 31 Jan'19 gets converted to 1 Jan'18 to 31 Jan'18. It automatically changes the year from 2019 to 2018. I have tried changing the system dates from control panel but it does not help. Any suggestions to correct this problem.


See more 

1 reply

Report Respond to ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1468
0
Thank you
A csv file, has no formatting. When you open it back up, don't open it from folder, but open EXCEL first, and then IMPORT the data, manually selecting a DATE for the date column!
Respond to ac3mark
Reply Ask a question