data validation.

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Im trying to limit what can be entered in a cell using
data validation. I want no text allowed and no comma's in
a range of cells. I have been trying to use formulas like

OR(ISNUMBER,<>",") but its not working. Any ideas how I
can do this?


TIA


Todd
 
Hi Todd,

Try formatting the cells as number and do not use
thousands seperator. For the DV just use =ISNUMBER(A1).
Adjust the cell reference to suit.

Biff
 
Back
Top