I have a spreadsheet that was an old 2013 spreadsheet with a macro. I have converted it to an .xlsm file in Office 365. There is a field that is supposed to be a date, but it shows the integer value of the date on the spreadsheet. The cell is set up as a Date format, I have tried changing it to different date formats, and it even shows as a date in the formula bar. It is really weird. Has anyone noticed something like this when changing versions of Excel?
I double checked that the old file in 2013 (.xls) format shows a date.
Excel small 2.jpg
Bookmarks