View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.