View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa BMW
 
Posts: n/a
Default editing in several tabs at once

While creating a formula in several tabs at once, my formula resulted in
"+R[-1]C*.541" instead of the "+N12*.541" I entered. But, this happened on
only the tabs that I wasn't directly updating. This showed as text and did
not give a formula result.

I went back and typed in the formula as "=N12*.541" and it worked correctly.
THe only difference was using "=" instead of "=".

Any ideas? THanks!