I need to convert numbers as text to values that can be added for a long column of entries. HELP
G geoexcel Feb 27, 2005 #1 I need to convert numbers as text to values that can be added for a long column of entries. HELP
M Max Feb 27, 2005 #2 One quick way .. Select the entire col, say col A Click Data > Text to columns Click Finish
E Earl Kiosterud Feb 27, 2005 #3 =SUM(A2:A65536+0) If there are any non-number text cells in the range, they'll confound this formula.
=SUM(A2:A65536+0) If there are any non-number text cells in the range, they'll confound this formula.
