| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cells for numeric entries only
Can cells in MS Excel be locked so that only numeric entries will be
permitted? Perhaps alpha entries will be omitted or come back with an error... is this possible? Thanks for any help. Matt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking cells for numeric entries only
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking cells for numeric entries only
Perfect! Thanks, Paul.
Matt "paul" wrote: take a look at data validation -- paul remove nospam for email addy! "matt ball" wrote: Can cells in MS Excel be locked so that only numeric entries will be permitted? Perhaps alpha entries will be omitted or come back with an error... is this possible? Thanks for any help. Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| QUESTION REGARDING LOCKING SPREADSHEETS AND PREFORMATTED CELLS | Excel Discussion (Misc queries) | |||
| Locking Cells ... Without Protecting Sheet | Excel Discussion (Misc queries) | |||
| Locking cells only for certain users | Excel Discussion (Misc queries) | |||
| Locking certain cells | Excel Discussion (Misc queries) | |||
| Locking certain cells | Excel Worksheet Functions | |||
Linear Mode
