View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default 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