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
|