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

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

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" <geoexcel@discussions.microsoft.com> wrote in message
news:49D3D9DE-73B6-4D34-8BBE-E9886EC81411@microsoft.com...
> I need to convert numbers as text to values that can be added for a long
> column of entries. HELP

=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" <geoexcel@discussions.microsoft.com> wrote in message
news:49D3D9DE-73B6-4D34-8BBE-E9886EC81411@microsoft.com...
>I need to convert numbers as text to values that can be added for a long
> column of entries. HELP