need Macro
Sadly I know every little about user interfaces, only Inputboxes and
Msgboxes.
I suggest you get started yourself. After all, you can always come here if
you get stuck.
--
Gary''s Student - gsnu200766
"ranchbroker" wrote:
I can not thank you enough.... do you do work on the side.... I need someone
to create a user friendly interface where by we can sort, print the sort, do
some math (very simple) etc...
Joe
"Gary''s Student" wrote:
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
|