April 4th, 2009, 03:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|
|
Columns labeled with numbers not letters
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Dan" wrote in message
...
Just wanted to say thanks for the answers on this thread...we spent about
an
hour trying to figure out how to fix this. Not sure how it got changed to
begin with, but using this - we got it done. Thanks.
"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
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?
|