Enforce format
 

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

Enforce format
 

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

"Elfey1001" wrote in message
...
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

Enforce format
 

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!




"Elfey1001" wrote:

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