Select the cells you want to convert and run:

Sub expression_to_number()
For Each r In Selection
r.Value = Evaluate(r.Value)
Next
End Sub

--
Gary''s Student - gsnu200766


"ranchbroker" wrote:

I need to convert the following formulas in a single column from a label to
the sum of the numbers in the cell.
The column is 10,000 lines long...

99.00+1
99.38+110
99.35+73
99.28+120.48
99.15+1
99.11+127.6+1
99.00++1
984+491+1
98+60
98+57.316+10
98+2