How do I make every thin in a column that is not >4000 assigned the "0" and
every cell >4000 assigned the "1" (and ignoring the letters)?

column might look like

4002
AB009
4001ab
2004
0078
45

--
Message posted via http://www.officekb.com