How to define cells so that only numbers can be filled?

  • Thread starter Thread starter Juha
  • Start date Start date
J

Juha

Hi,

How could I format cells in excel so that only numbers can be filled
The input should be integer e.g. between 0...99 and cells shoud no
accept any other marks, such as space, letters... simply nothing els
but integers.

Thanks
 
Hi Juha!

Try:
Data > Validation

You'll find it pretty intuitive and very flexible as to what you can
do as far a restricting input to a cell.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Select the cells you want this restriction to apply to and then select
Data/Validation ( from the menu ). Select Allow Whole Numbers and set
the minimum and maximum values. You can even include an input message (
which appears when the cell is selected ) and an error message.
 
How could I format cells in excel so that only numbers can be filled?
The input should be integer e.g. between 0...99 and cells shoud not
accept any other marks, such as space, letters... simply nothing else
but integers.
Click to expand...

You can go to the Data menu, Validation item and set validation so
that only whole numbers between 0 and 99 are allowed.

Be aware that this is NOT foolproof, and will not prevent a user (for
example) pasting an invalid value from another cell into your entry
cell. However it should do for most purposes.
 
Juha,

If you go into Data>Data Validation, you will see that there are options
there to specify whole or decimal numbers, and you can set limits.

Other than that, it is probably VBA.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top