Enforce format

[Elfey1001]

How can I "enforce" a format in a cell in excel so that it allows number
entry only, i.e. it does not allow letters or any other characters.
Thanks in advance.
Keith

 

[Bob Umlas]

Data Validation; custom formula; If active cell is A1, use this:
=NOT(ISERROR(1*A1))

 

[trip_to_tokyo]

In EXCEL 2007:-

Data / Data Tools / Data Validation / Data Validation / Settings tab /
Allow: field - in here you can do what you want plus a variety of other
options.

If my comments have helped please hit Yes.

Thanks!