Restricting Cell Format

[zhj23]

Is there a way to restrict a cell to a certain format, such that the user
cannot input other formats other than the preset one?
For example: preset the cell to numeric, user cannot input text or dates.

Many thanks.

 

[Bob Phillips]

Data Validation can do that to an extent. It can restrict to a number, no
text, but dates are just numbers, so that is a problem. See
www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[zhj23]

Thank you, Sir.

At least the problem can be partially solved.

 

[Bob Phillips]

The other way is event code to trap it as entered.

--

HTH

RP
(remove nothere from the email address if mailing direct)