100*50 to =100*50

  • Thread starter Thread starter Mortir
  • Start date Start date
M

Mortir

I have an entire column written as in example 100*50 (without =),
which of course means that the equation doesnt caltulate... what would
be the easiest way to correctly define the equation as =100*50 that it
would properly calculate itself...
 
One way

Assume source data in A1 down
Put in B1: ="="&A1
Copy B1 down. Kill the formulas in col B
with an "in-place" copy n paste special as values.

Then with col B selected, click Edit > Replace
Find: = , Replace with: =
Click to "Replace All"
 
A further option...

- Check Tools > Options > Transition Formula Entry
- Select column and choose Data > Text to Columns > Finish
 
Back
Top