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.