If the contents of the cell are text, then the various number options under
Format Cells will have no effect.
Use =ISTEXT(cellref) and =ISNUMBER(cellref) to tell you whether the contents
are text or number.

Is it just the number formats that you can't change? Can you change colour,
for example?
--
David Biddulph

"WildeWest" wrote in message
...
I have some cells that have somehow become like they are frozen. They are
not
protected but when right click or select 'Format''Cell' nothing happens
and
I can't format those certain cells. Can someone tell me how to fix this
please?