Select the column
F5Special
Constants
Uncheck all under Formulas except Text
OK

You can no delete the cells or complete rows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"evoxfan" wrote in message ...
I have a column with blanks, text, and numbers.

I want to delete the text and keep all numbers.

What is the easiest way to do this?