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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you convert numbers as "text" to values for a long column . (https://www.excelbanter.com/excel-discussion-misc-queries/15209-how-do-you-convert-numbers-%22text%22-values-long-column.html)

geoexcel

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

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 <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

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

All times are GMT +1. The time now is 07:51 AM.