=SUM(A2:A65536+0)
If there are any non-number text cells in the range, they'll confound this
formula.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"geoexcel" wrote in message
...
I need to convert numbers as text to values that can be added for a long
column of entries. HELP