Does the cell have some conditional formatting behind it? This might be
disguising your attempted changes.

From the menu: Format Conditional Formatting

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Ron West" <Ron wrote in message
...
It is almost as if the cell is locked and I cannot change any of the
formats
inside the cell