Changing the number format from Date to Fraction doesn't work if the cell already contains a date. You must make the formatting changes before you add the values.

Microsoft Excel normally does not let users change the values of protected cells. To edit a protected cell, you must first remove its protected status.