Try this:

Select the range of cells to be impacted
Press the [F5] key........a shortcut for <edit<go to
Click [Special]
Select: Formulas.....Uncheck: Text
Click [OK]

That will select all of the numeric values (and errors)
Press the [Delete] key to erase the contents of the selected cells

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"thd3" wrote in message
...
I have a column with numbers and text - I want to delete all numerical
values
and leave the text intact. Any help would be greatly appreciated.