View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Formula appears as =RC[-3]+RC[-1] Whats this?

ToolsOptionsGeneralR1C1 Reference Style, uncheck it

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Concrete Guy" <Concrete wrote in message
...
I am getting formula formatted as =RC[-3]+RC[-1] when simple Row and

Column
references is what I desire to see. I don't know how to interpret the

formula
as shown when I select that cell. I type in the typical Row/Cell location

but
it gets displayed as above. an anyone help????