Hi, my first post here = newbie!
Excel for Mac 2011
Whatever I try I can not get dates to display in date format, eg. 20/05/2013 is displaying at 39934. The date displays correctly in the formula bar and behaves as a date in all other respects, it just doesn't display on the sheet in the correct format. I've tried everything I can think of to reformat but to no effect.
I've got the feeling there is a simple solution but I'll be damned etc. etc.
Dreddi
Bookmarks