Excel for Mac 2011, running OS Sierra - In one spreadsheet only the - Microsoft Community

in 1 spreadsheet dates changed after restart 5 digit numeric values , attempt re-format column or individual cells std dates  fails. there no changes in preferences made. tried copying date format other spreadsheet returns 5 digit values.  strangely  enough in new workbook dates have correct format! gives?  help please before lose mind! appreciated!

hi krystyna,

try formatting date, see if works. this, please follow steps below:

1. select cells want format.
2. on mac, press control+1 or command+1.
3. in format cells box, click number tab.
4. in category list, click date.
5. under type, pick date format. format preview in sample box first date in data.

in addition, please check system preference> language , region> advanced>dates.

if issue persists, please provide following information:

1. in excel, go excel menu , choose about excel, confirm version , build.
2. do existing spreadsheets show same behavior or one?

thanks,

neha

Office / Excel / Mac / Office 2011 for Mac