Validation of numbers

  • Thread starter Thread starter KrisB_bacon
  • Start date Start date
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
 
Hi
try entering the following formula in the ata validation dialog
=ISNUMBER(your_cell_reference)
 
Back
Top