Sep 07 2020 12:04 PM
I have a web application that collects information including dates. I can download the information in a CSV file. The date value that is collected is stored in the cell with the mm/dd/yyyy format but is displayed as mm/dd/yy. Is there a way to change the default way the cell value is displayed so that it is always mm/dd/yyyy ?
Here is a link to a screenshot. Screenshot of CSV file date format (it's also in the attachment)
Sep 07 2020 12:56 PM
Nov 11 2022 05:44 PM - edited Nov 11 2022 05:46 PM
Nothing works for me on this. I open/import a CSV file and the column of dates is all dd-mmm-yy. I'm always having to format to mmm-dd-yyyy.
Excel does recognize the data as a date.
I've been through all Options in Excel (365 Business - Win 10) and all Control Panel (new and old) settings for time, date and other regional default settings. I even put mmm-dd-yyyy as both the long and the short date format. All to no avail.
While asking about default settings, is there a way to quickly change column width to fit the contents? Or set that as default?
Even created a macro to set the above but that can get quite tedious to after a while.
Thank you.