Column heads are numbers

[peter.mac]

Something very strange has happened to my EXCEL documents. The column
heads are no longer letters (A, B, C, etc) but instead they are numbers
(1,2,3, etc). How do I get the letters back?

TIA

 

[Chip Pearson]

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Tools --> Options --> General Tab

Uncheck box for "R1C1 Reference Style"

HTH,
Elkar

 

[Nick Hodge]

Peter

Tools>options...>general and un-check R1C1 Reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[peter.mac]

Thanks folks. The switch for this is actually in the Excel Preferences
area (I'm using 2004). Your help allowed me to search R1C1 and find the
toggle.