cell location is locked cannot format it

[Dennisr53]

Hi Everyone,

Someone got into my spreadsheet and locked a cell so I cannot format it. How can I find out how they did it and how can I unlock it?

cell G1 has the date January 1,2017 in cell G2 I have (=G1) and custom formatted to "d" to show the day only but it shows January 1,2017. No matter what I do to the cell G2 I cannot change the January 1,2017 it never changes.

Any help would be greatly appreciated.

Thanks,
Dennis

 

[mumps]

In order for the cell to be locked and not accessible, the sheet must be protected. Try unprotecting the sheet. If it's protected with a password, then you will need to know the password to unprotect it.