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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why i have my exel formula like this =L[-310]C+L[-256]C+L[-2]C (https://www.excelbanter.com/excel-discussion-misc-queries/77683-why-i-have-my-exel-formula-like-%3Dl%5B-310%5Dc-l%5B-256%5Dc-l%5B-2%5Dc.html)

ppereira

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

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

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

All times are GMT +1. The time now is 08:46 AM.