Formula's don't work until I "touch" them?
"Maury Markowitz" wrote in
message ...
"Fredrik Wahlgren" wrote:
There's an easier way. Do a Find&Replace and replace all equal
signs with equal signs.
That worked. Ok, why?
Maury
I think you insert the fourmulas as text. It is perfectly possible to do so.
When you replace an equal sign with an equal sign, Excel will understand
that what begins with an equal sign should be treated as a formula.
Essentially the same as when you "touch" them.
/Fredrik
|