Restricting Cell Format
 

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.

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" wrote in message
...
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.

Thank you, Sir.

At least the problem can be partially solved.


"Bob Phillips" wrote:

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" wrote in message
...
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.

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

--

HTH

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


"zhj23" wrote in message
...
Thank you, Sir.

At least the problem can be partially solved.


"Bob Phillips" wrote:

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" wrote in message
...
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.