Excel stopped formatting

[laqa]

My Excel just stopped formatting cells. Even if I select the column and use the format cells command again it does not work. I tried to select one cell and when I chose "format cells" came a dialog box where I could format the font. I am an university professor and use this command a lot to change dates into numbers to grade students by their task delivery date. Can someone help?

 

[Sufiyan97]

Try closing excel with task manager and open it again..

 

[laqa]

Try closing excel with task manager and open it again..

Thank you very much, but it did not work.

 

[MARK858]

You haven't accidently set any sheet protection or have conditional formatting on the cells?

 

[laqa]

You haven't accidently set any sheet protection or have conditional formatting on the cells?

Thank you very much, but I do not know how to set sheet protection and there is no conditional formatting (this one I know).

 

[MARK858]

but I do not know how to set sheet protection

On the Review tab, in the Protect section does it say Protect sheet or Unprotect sheet?

 

[laqa]

On the Review tab, in the Protect section does it say Protect sheet or Unprotect sheet?

Thank you, it is not protected.

 

[laqa]

Thank you, it is not protected.

It says protect, so it is not protected. Thanks again.

 

[MARK858]

I take it you have no VBA (macro's) in the workbook? and is this happening on all workbooks or just the one?

 

[laqa]

I take it you have no VBA (macro's) in the workbook? and is this happening on all workbooks or just the one?

Thank you very much. No macros. All workbooks.