January 19th, 2009, 07:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|
|
Columns labeled with numbers not letters
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
news
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?
|