Select all of the cells. (The easiest way to do this is to click in the little box at the upper left corner above the row labels and to the left of the column labels.) Right-click on the selected cells. (That is, anywhere on the sheet.) Select "Format Cells". Click on the "Number" tab. Select the "Text" category. Click "OK".

Now all of your cells are in text mode and will not reinterpret what you type into them.

It also means you won't be able to do date arithmetic.


No, but "mmmm yyyy" is and will meet your template criterion. (You have to enter this in the "Custom" category, if you don't already know that.)

Edit: I think I may have misinterpreted your request. If so, sorry.