my column headers has changed to numeric from alphabetcal order

A

Annie

I have come across strange problem ..my column names has chnaged to numeric
from alphabet and now none of my formulaes work as all the cell names show
up as R1C1 , R1C2 and so on...

Anyone knows what have i messed up ???
 
H

Harald Staff

Tools > Options > General, uncheck R1C1 style.

(This is a workbook setting that overrides the application settings. So you
may have opened a workbook using this style.)

HTH. Best wishes Harald
 
Top