If you unlock the cell or range of cells and protect the worksheet, you also
protect the format. Excel has an option to allow users to change formats in
protected cells, which you can tick if you want to allow this.

Cheers,

Kassie

"John Louis" wrote:

I want to protect the cell format like in a sheet protection of a cell, so
that for other users can change the content of the cell but not use 'Format
Cell Number' to chage the format let say from a time to a %

"John Louis" wrote:

In excel how do I protect the format of a cell but let the user change the
cell value?