Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need Macro
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need Macro
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |