Hi,
not sure if I asked this before or it's in the archive forum but how can we change MM/DD/YYYY to YYYY/MM/DD in excel
In cell A1, it contain 01/30/2015
I tried to change via Format Cells --> Number --> Customs --> change to YYYY/MM/DD but no changes
If it's 30/01/2015, then yes, in the Customs, change to YYYY/MM/DD will work perfectly.
Appreciate all the Excel professors here.
Thanks
cks1026
Bookmarks