Add an "=" sign to multiple rows.

[shaju]

Hi all,
I am having a table which is obtained from SAP. It has a column with numbers, which I want to work with. I just want to add an "=" sign in front of all the values in column E so that calculations based on that values can be done. Is this possible.
(What I am doing now is, entering "=" sign in another column and concatenating these cells with corresponding cells in Col E and then copying and pasting the values again in another column to work with.) Is there a more easier way...???
TIA

 

[Rick Rothstein]

Hi all,
I am having a table which is obtained from SAP. It has a column with numbers, which I want to work with. I just want to add an "=" sign in front of all the values in column E so that calculations based on that values can be done. Is this possible.
(What I am doing now is, entering "=" sign in another column and concatenating these cells with corresponding cells in Col E and then copying and pasting the values again in another column to work with.) Is there a more easier way...???

If I understand what you are saying correctly, you have a column of numbers that have been placed in such a way that they are all text values instead of numeric values. If that is correct, select the entire column, call up the Text To Columns dialog box (Data tab, Data Tools panel) and press finish as soon as the dialog box appears.

 

[shaju]

Thanks A Lot for looking into this matter. Actually, these values are numbers in number format. I want to deduct values from these cells.
Example:
E1 has the value say, "5000" in it. I just want to change the cell value to "=5000",so that I can perform additions or substractions from the value 5000....like =5000+7500 or =5000-2500, as need arises. Or in other words, I just want to add an "=" sign to the first character in every cell in Col E.

 

[shaju]

The last line should be read as
Or in other words, I just want to add an "=" sign AS the first character in every cell in Col E

 

[Rick Rothstein]

The last line should be read as
Or in other words, I just want to add an "=" sign AS the first character in every cell in Col E

Give this macro a try...

Sub AddEqualSign()
  With Range("E1", Cells(Rows.Count, "E").End(xlUp))
    .Formula = Evaluate("""=""&" & .Address)
  End With
End Sub

 

[shaju]

Thanks A Ton. It worked as I wished.....