Limiting to one number
 

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...?

Limiting to one number
 

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.

" wrote:

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...?