Date formatting won't work

Hi guys,

I am having this unique issue with a worksheet which pulls data from a .csv file. The data contains dates and the formatting for the date column is set to "Short Date". But, when the data gets pulled, rather than getting something like "1/1/2021", I am getting "1/1/2021 12:00:00". The weird part is that it happens only in my Boss's computer, which is where they review the report that I make. We run the same version of Excel (2016). I tested the report on two other workstations in my office and it works just fine. I checked the Connection Properties and it is set to retain cell formatting while pulling data from .csv file.

Am I missing something here or is there a specific setting in Excel which I need to change to fix this?

Appreciate any help offered.

Thanks

To add another point, the excel file does not get moved around via email. It is stored in a central network location where anyone who has access to the folder can view and edit the file.

It could be your boss's computer short date setting:

Short Date Settings.png

FDibbins: Appreciate your inputs. I checked that but I don't think .csv import is causing this issue because it works fine in my computer. This issue is only with my Boss's computer. I tested this on several other computers and did not have the same issue. Also, the connection between the excel file and the .csv file is set to retain source formatting. I'm still not sure why the formatting is different.

Josephteh: Thanks for your response. I checked this settings but it looks fine too.

As a fix, I added a line to my VBA code to change the number format to display "mm/dd/yyyy". I would still appreciate any inputs to find out what is causing this issue in just one computer. I'm pretty sure I'm missing on some settings and I don't know where.