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.