We definitely need a FAQ for this group.

2003 to 2007 cross-reference:
http://office.microsoft.com/en-us/ex...491511033.aspx
--
David Biddulph

"Pella Engineer" <Pella wrote in message
...
There is no Tool/Option on the toolbar in Office 2007. How do I get the
coumn
headers converted from numbers to letters in this case?

"plumeria54" wrote:

Thank you - that was too easy...!

"Rick Rothstein (MVP - VB)" wrote:

Click Tools/Options on Excel's menu bar, select the General tab on the
dialog box that appears and uncheck the box next to the label "R1C1
reference style" in the Settings section.

Rick

"plumeria54" wrote in message
...
My spreadsheets suddenly show numbers for the columns instead of
letters --
columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in
cells
now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5
How do I change the columns back to letters?