I have a strange formatting error in Excel 2011 for Mac which happens when I try to format cells as Date.
If I right click on a group of cells or a column and choose Format Cells, then in the dialog, Date, and choose any of the preset formats such as; dd/mm/yy the result never includes the correct year, or month.
For example, if I enter 29.6 into a cell the result would be 29/01/00
If I enter 29/6 then the result comes out as 29/6
I have checked the preferences, and cannot find anything that will allow me to change the date preferences in Excel other than to use the 1904 date system.
Anyone have any idea how to fix this?
If I right click on a group of cells or a column and choose Format Cells, then in the dialog, Date, and choose any of the preset formats such as; dd/mm/yy the result never includes the correct year, or month.
For example, if I enter 29.6 into a cell the result would be 29/01/00
If I enter 29/6 then the result comes out as 29/6
I have checked the preferences, and cannot find anything that will allow me to change the date preferences in Excel other than to use the 1904 date system.
Anyone have any idea how to fix this?