I download a weekly spreadsheet that has the date format at 09/01/2000, I need to change that date format to 2000-9-1. I have not found many articles that I can follow that will show how to change an existing date, everything so far is about formatting the today date.
Can anyone offer any help on how I would take the date format I am given and change to a new non standard format in Excel?
Current date format is 09/01/2000
Wanted format is 2000-9-1