Date settings

[arigil]

Hello. I export a file from a platform at work and the dates appear in the cells like this in my Excel 2019-03-11, but other coworkers export the same file and the dates appear correctly in their Excel as 11/03/2019. Does anyone know if there is a setting in my Excel that needs to be fixed in order for the dates to appear correctly? I know that with Text to Columns it can be fixed but there are too many columns and it will take a lot of time. Please HELP!!!

[Melvosh]

Right click on one of the dates, choose format cells. When the dialog box comes up, select the Date category, then choose the format you want. If that works, you can format the rest of the date cells that way as well.

[arigil]

Excel doesn't even recognize it as a date format, it takes it as text, so format cells to date does not work.

[dosydos]

sounds to me perhaps they have different locale than you. You should be able to change your locale to the correct one that you want to show and it will change the mm/dd/yyy to dd/mm/yyyy or vice versa. Below i took a screeshot of when i changed mine from English (United states) to Spanish(mexico)

[Melvosh]

Select the column, go to the Data menu, hit the Text to Columns button. When the dialog box opens up, select Delimited, leave Tab as the delimiter, and set the Column data format to Date. Specify the date style you want, and click Finish. That should do what you want.

If this data is a CSV file imported into Excel, there should be an option to set the format of this column during import.