Limiting to one number

S

swen

I have few fields in excel where I should input numeric data (i.e.
days of the week - from 1 to 7)
Anybody know how can I limit cell to allowing input on juts one number
to prevent wrong input? Limiting decimal places is easy but limiting
main numeric field...?
 
S

Sloth

Highlight the cell and click on Data->Validation. Select "whole number" in
the first box. Select "Between" in the second. And input 1 and 7 as the
minimun and maximum.
 
Top