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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top