In Validation box select Custom and enter the formula ISNUMBER=True.

Mike F
"scaundle" wrote in message
...
Hi,

Is there anyway that I can stop a user adding any other value than a
number,
I have put in place validation but the users can still add their own
formula,
eg =sum(A1:A4)

This causes a problem as if the have added a value incorrectly into one of
the 'summed' fields it is hard to locate the error!

Thanks in advance for your help.

Steve