This kind of protection was added in xl2002.

The tools|protect|protect sheet
has a bunch more options.

There are a couple ways around it.

You could copy a cell that was formatted the way you want and then
edit|paste special|formats

If you're developing a tool for others, you could provide a macro that did the
work of unprotecting the sheet, changing the format and reprotecting the sheet.



MargaretAnnM wrote:

I have protected a range of cells in a worksheet. Although it is possible to
enter a formula in the unlocked (unprotected) cells on the same sheet, it is
not possible to reformat those cells, e.g format them as % or change the
number of decimals displayed. Is there any way to allow formatting on the
unlocked cells? Thanks

--

Dave Peterson