once the format is set the data entered will match the format
Cheers peterm

"John Louis" wrote:

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