Data Validation

[Grant Reid]

Hi

Hope some genius out there can help.

I need to ensure that users enter a numeric value in the current cell of a
range of cells. I've attempted to use the "Data Validation" feature of Excel
but do not want to restrict the user to a particular range of numbers, but
merely to restrict them from entering a text value. I selected my
"Validation Criteria" as "Custom" with a "Formula"
=ISNUMBER(CELL("address")). This approach only seems to work on the first
cell in the range. Subsequent entries in the other cells in the range where
this validation is applied fail.

Can anyone shed some light on this? Am I taking the wrong approach, or is my
logic flawed. Any help will be much appreciated.

Kind Regards - Grant

 

[Mangesh Yadav]

Just select all the cells and enter the following
=ISNUMBER(A1)
in the custom.

- Mangesh

 

[Grant Reid]

Hi Mangesh

Many thanks for your help.

Kind Regards - Grant