Thank you very much for posting this! I am still not sure how I flipped it,
as I know I was not in that screen before, but at least it is fixed now!


"T. Valko" wrote:

In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

--
Biff
Microsoft Excel MVP


"tstrong5" wrote in message
...
I am having the same problem. Did you find an answer?

"Pella Engineer" wrote:

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?