There are a handful of capable, solid spreadsheet apps for Mac, but we've got our money on Excel thanks to its rich feature set, cross-platform (and web) compatibility, and data management tools. Download Numbers for macOS 10.13 or later and enjoy it on your Mac. ā€ˇCreate gorgeous spreadsheets with Numbers for Mac. Get started with one of many Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more.
Excel for Mac 2011 14.1.0 on iMac OSX 10.7.5. I see no forum category for Microsoft Office for Mac so just chose iMac. Checked Microsoft site first with no success.
PROBLEM:
In new spreadsheet I selected one column and formatted to date format.
It was working fine. Then after I'd been doing some editing and having issues, I closed the file then opened it again.
The cells/column I'd formatted for dates was showing the date as strange numbers. Like this: Instead of 9/12 it shows 41894.
Even though the individual as well as column cell format is still 'Date' with example style of '3/14' selected, it will not work.
I cannot find a way to 'Clear Formatting' either -- only Clear Contents.
![Microsoft excel for mac 10 5 8 Microsoft excel for mac 10 5 8](/uploads/1/2/6/2/126227572/180357691.png)
However, when I cut and paste the cells to another worksheet the date is fine -- but I've lost all my formatting and don't want to start over. Besides, I need to know what is causing the problem.
HELP!! Is this a bug?
iMac
Posted on