One quick way ..

Select the entire col, say col A
Click Data Text to columns
Click Finish
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"geoexcel" wrote in message
...
I need to convert numbers as text to values that can be added for a long
column of entries. HELP