Validation of numbers

K

KrisB_bacon

hey

I want to validate a cell so that it will only accept numbers, no
text. These numbers could be decimals or whole numbers, therefore th
Whole number option won't work. I tried the Decimal option, but i
still allowed text. Can u help??


Thx


KrisB_baco
 
F

Frank Kabel

Hi
try entering the following formula in the ata validation dialog
=ISNUMBER(your_cell_reference)
 
Top