View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Cell Reference Weird Format

ToolsOptionsGeneral tabuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"elementhunter" wrote in message
...
Hi There,

Somehow I managed to turn my cell references into a weid format... IE:
R1C1
and then when I do a formula it is R[-1]C[-2]

Is there any way to turn it back to where the formula reads B3? Thanks!