Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column label appear as numbers, not letters

Status
Not open for further replies.

swk

Technical User
Sep 19, 2002
48
US
I am new to this, so please forgive me if this appears too obvious however...

I created a new worksheet from an imported text file and began the task of identifying the data in columns. Once I began the process of analyzing the data I realized the both columns and rows were identified with numbers, rather than the usual combination of numbers for rows and letters for columns. While I can deal with this, it is making the rather complex analysis I need to do even more problematic. Any suggestions on how to change this back to a more traditional arrangement?

TIA for any assistance

swk
 
Go to
Tools>Options>General
Untick R1C1 reference style

HTH Rgds
~Geoff~
 
TOO Easy! Thanks!

swk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top