formulas are reading weird
 

when I click on the function key and try to input a formula by clicking on
different cells (ie B6, C3), the formula records something wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in the future and
others can see where the calculations are coming from. If I type the exact
number, it's ok. But I want to be able to click on the cells instead.

Hi
goto 'Tools - Options - General' and uncheck 'R1C1 reference style'

--
Regards
Frank Kabel
Frankfurt, Germany

"darcerella" schrieb im
Newsbeitrag ...
when I click on the function key and try to input a formula by
clicking on
different cells (ie B6, C3), the formula records something
wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in the future
and
others can see where the calculations are coming from. If I type the
exact
number, it's ok. But I want to be able to click on the cells
instead.

Hi!

It sounds like you are using the R1C1 reference style.

Are your column headers numbers and not letters?

To change it goto ToolsOptionsGeneral Tab.
Uncheck R1C1 reference style.

Biff

-----Original Message-----
when I click on the function key and try to input a
formula by clicking on
different cells (ie B6, C3), the formula records
something wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in
the future and
others can see where the calculations are coming from.
If I type the exact
number, it's ok. But I want to be able to click on the
cells instead.
.

Try ..

Click Tools Options General tab
Uncheck "R1C1 reference style" OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"darcerella" wrote in message
...
when I click on the function key and try to input a formula by clicking on
different cells (ie B6, C3), the formula records something wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in the future and
others can see where the calculations are coming from. If I type the
exact
number, it's ok. But I want to be able to click on the cells instead.