| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I was wondering how to have excel have a specific number input
I was wondering how to have excel have a specific number input only. For
example I make a grade spread sheet, and I have where I can put grades on the horizontal row. Is there a way, where only the numbers of 1 though 100 can be imputed and nothing else. Like if I put over 100, it would say error or not allowed or something? I realize I can lock everything else, But I still want it, so it will keep it within a data range, encase I make a mistake or something and excel could pick it up. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I map the route of curser to specific input cells excel | Excel Discussion (Misc queries) | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| We were wondering how to edit an array once it has been set up? | Excel Worksheet Functions | |||
| Nothing to do with Excel....wondering if there is a way to check.. | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Threaded Mode
