=IF(AND(Sheet1!A10,Sheet1!A1<10),Sheet1!A1,0)
if you want a-z also, does case (Uppercase/lowercase) matter?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob" wrote in message
...
Hi
I am working with a spreadsheet and would like to know if there is a
function to pick values from a spreadsheet into another spreadsheet when
the
values are only 0-9 and make everything else to a blank or 0.


Thanks