Jon Peltier writes
To convert any nonnumeric values into numbers, copy a blank cell,
select the cells to change, and from the Edit menu, select Paste
Special, using the Values and Operation - Add options.

Thanks for that tip. I've never had a problem finding those nasty
hidden text numbers in my data sets, but converting them to numeric has
always been a pain. Now I don't have to F2, Enter all the way down the
column any more.

--
Del Cotter http://del_c.livejournal.com/

Send email to del2 at branta dot demon dot co dot uk