100*50 to =100*50
 

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...

100*50 to =100*50
 

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"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mortir" wrote:
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...

100*50 to =100*50
 

Hi Mortir,

Here is an interesting take on that situation which I only
discovered last week. Scroll down to the Excel tips and tricks
bit and follow the instructions precisely. You will then see how
to adapt it to your purposes.

http://www.ozgrid.com/News/excel-eva...ormula-VBA.htm

HTH
Martin



"Mortir" wrote in message
...
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...

100*50 to =100*50
 

A further option...

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

"Mortir" wrote:

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...