Why i have my exel formula like this =L[-310]C+L[-256]C+L[-2]C

P

ppereira

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
 
D

Dave Peterson

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"
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
Click to expand...
 
Top