In 97-2003 toolsoptionsgeneral, then deselect R1C1 reference style

in 2007 office button, excel optionsformulas under working with formula and
deselect the same check box


For future posts include Excel version

--


Regards,


Peo Sjoblom


"mac" <mac @discussions.microsoft.com wrote in message
...
my default used to be column a, column b etc, somehow it has been changed
to
column 1, column 2 etc. how do I change it back? Because of the default
change it changes my formulas to sum(R[1] - C[2] etc.