data validation.

[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

 

[Biff]

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