want to get that equal sign in..

[ursula jung1975]

so i have a problem. I have many numbers that i would like to add that are basically not in formula form, but rather like values. imagine 2 columns like this -
Price A ($/mt) Price Z ($/mt)
933.77+936.09 891.00+899.00
817.62+819.29 672.50+681.25
1019.00+1020.95 784.33+789.00
964.14+967.10 752.60+757.40
958.61+960.50 741.25+745.75
So Price A column and Price Z columns are different, and like that, there are several more prices, and columns.
My question is, how can I ask excel to put in an equal sign in front of these values (to basically convert 933.77+936.09 to =933.7+936.09 or 1869.86) instead of going individually in each cell and putting an equal sign in front of the two numbers.
thanks
ursula

[Trebor76]

Hi ursula,

You could try the following macro on the two columns in question - just change the starting cell (as flagged in the code):

Please Login or Register  to view this content.

HTH

Robert

[starguy]

so i have a problem. I have many numbers that i would like to add that are basically not in formula form, but rather like values. imagine 2 columns like this -
Price A ($/mt) Price Z ($/mt)
933.77+936.09 891.00+899.00
817.62+819.29 672.50+681.25
1019.00+1020.95 784.33+789.00
964.14+967.10 752.60+757.40
958.61+960.50 741.25+745.75
So Price A column and Price Z columns are different, and like that, there are several more prices, and columns.
My question is, how can I ask excel to put in an equal sign in front of these values (to basically convert 933.77+936.09 to =933.7+936.09 or 1869.86) instead of going individually in each cell and putting an equal sign in front of the two numbers.
thanks
ursula

Try using a helper column next to the data column and put following formula.
="="&A1 and copy it down.
Copy the helper column and Paste special as values in another place. Keep it selected and press Ctrl+H and set options as follows.
Find what: =
Replace with: =
and hit Replace All

Now copy or cut this last column of data and paste over your original data.