Forum Discussion
MO 365 Excel - Difficulty Changing a Date format
I am using MO 365 - apps for Business, currently received an Excel Spreadsheet and am attempting to change date format in Excel and have tried all the usual methods however the dates remain unchange...
if you have tried various date formats and they haven't changed, my guess is they are actually TEXT that just look like dates. You can try DATA -> Text to Columns and just next through to step 3 and select Date: MDY and then Finish. After that the data should now be actual dates and you can change the format accordingly (under 'more number formats' and then Date and yyyy-mm-dd is listed 3rd on my app or you can go to custom and specify yyyy/m/d for the format you listed but note I believe the international standard (ISO 8601) is actually yyyy-mm-dd (and there are some variants allowed but I don't believe the use of / is one of them).