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

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