Hi Tim,
you want Validation

Validate / Validation
http://www.mvps.org/dmcritchie/excel/validation.htm

When doing Data Validation you select a range, the formulas will be
applied to the entire range based on the formula in the active cell,
which would normally be the first cell in the range.

Select Column B
Data, Validation, custom, formula is: .

your test could be
=ISNUMBER(B1)
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tim" wrote in message ...
I am trying to set a column to have only numbers and reject or spit out anything else.