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!

editing in several tabs at once
 

I was able to duplicate that. Very interesting. Excel only knows to put
the "=" in for you on the active sheet evidently. And also evidently Excel
enters formulas in R1C1 format initially too. Too weird. Well, in any
case, you have to enter formulas 'properly', that is, with an "=".

--
Jim
"Lisa BMW" <Lisa wrote in message
...
| 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!