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