View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Why i have my exel formula like this =L[-310]C+L[-256]C+L[-2]C

I use xl in English.

For me, I'd use:
tools|options|General tab|uncheck R1C1 reference style.

Yours may be "uncheck L1C1 reference style"

ppereira wrote:

I have Microsoft office professional edition 2003. I have an exel document
with Pivot table and the format of the formula changed to

=L[-310]C+L[-256]C+L[-2]C

I dont know what the cause of this change


--

Dave Peterson