How do I switch from 1,2,3... back to A,B,C... column reference na

I noticed in Excel 2003 both the rows and columns are numbered. As far
creating and maintaining Excel formulas, I'd prefer the previous column
labeling. Does anyone know how to switch back to the A,B,C labeling once a
file has been saved and updated to the latest version of Excel?

C, tools, options, general, uncheck R1C1 ref. style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"C. White" <C. [email protected]> wrote in message
news:[email protected]...
>I noticed in Excel 2003 both the rows and columns are numbered. As far
> creating and maintaining Excel formulas, I'd prefer the previous column
> labeling. Does anyone know how to switch back to the A,B,C labeling once
> a
> file has been saved and updated to the latest version of Excel?

Hi

its a setting - tools / options / general - untick r1c1 reference style

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"C. White" <C. [email protected]> wrote in message
news:[email protected]...
>I noticed in Excel 2003 both the rows and columns are numbered. As far
> creating and maintaining Excel formulas, I'd prefer the previous column
> labeling. Does anyone know how to switch back to the A,B,C labeling once
> a
> file has been saved and updated to the latest version of Excel?