Hi

I am updating a general log sheet and having some seriously frustrating
formatting issues. It's a protected sheet which I have unprotected yet I'm
still unable to update the cell format. Though the properties say that it is
in the format I want - 13:30 - it is still displaying as mm/dd/yyyy hh:mm PM.
I've tried everything from clearing the entire contents of the cell to using
the format painter and I'm still at a loss. Any idea how to ensure that
formatting changes are applied? Any help offered would be greatly appreciated.