I received an excel file from a coworker in Texas, while I reside on the east coast. I thought nothing of it, until i was putting a series of dates in to it from another spreadsheet i had created previously. I realized that instead of the date displaying as "DD/MM/YY" in the excel file I was sent, the date was now displaying as "MM/DD/YY 7:00:00". In addition, all the dates were now off by -1 day i.e. a date that originally was 11/17/2008 was now displaying as 11/16/2008 7:00:00.
When I clicked on formatting, it said that that was an asterisk'd date. That has never meant anything to me, but i guess its worth noting. I tried everything to reformat the date so it a) displayed the way i wanted it to (DD/MM/YY) and b) it corrected the error of being behind one day. absolutely nothing worked.
i got so frustrated with everything I closed all the files and decided I would get a new original file with the original data and start fresh. I ran this report from a cloud based system, which i've done thousands of times, and exported to excel...only to now discover that no matter what the data looks like prior to my downloading it into excel, the dates will now only display in the "MM/DD/YY 7:00:00" format.
I've never experienced this bizarre issue, and while i was able to use a ROUNDUP formula to eventually correct the data, the point is, i shouldn't have to. Up until I received the file from my co-worker, i've had zero issues with downloading reports into excel and the dates not appearing as they should. I may be entirely off base, but the only thing i can think of is that somehow the file i received from my coworker messed up my settings somewhere.
if anyone has any insight or solutions, you would be my hero!
When I clicked on formatting, it said that that was an asterisk'd date. That has never meant anything to me, but i guess its worth noting. I tried everything to reformat the date so it a) displayed the way i wanted it to (DD/MM/YY) and b) it corrected the error of being behind one day. absolutely nothing worked.
i got so frustrated with everything I closed all the files and decided I would get a new original file with the original data and start fresh. I ran this report from a cloud based system, which i've done thousands of times, and exported to excel...only to now discover that no matter what the data looks like prior to my downloading it into excel, the dates will now only display in the "MM/DD/YY 7:00:00" format.
I've never experienced this bizarre issue, and while i was able to use a ROUNDUP formula to eventually correct the data, the point is, i shouldn't have to. Up until I received the file from my co-worker, i've had zero issues with downloading reports into excel and the dates not appearing as they should. I may be entirely off base, but the only thing i can think of is that somehow the file i received from my coworker messed up my settings somewhere.
if anyone has any insight or solutions, you would be my hero!