Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |