How do you convert numbers as "text" to values for a long column .

[geoexcel]

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

[Max]

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 <at>yahoo<dot>com
----
"geoexcel" <[email protected]> wrote in message
news:[email protected]...
> I need to convert numbers as text to values that can be added for a long
> column of entries. HELP

[Earl Kiosterud]

=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" <[email protected]> wrote in message
news:[email protected]...
>I need to convert numbers as text to values that can be added for a long
> column of entries. HELP