column changed from alpha to numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

i am using excel 97.

the column heading used to be A , B , C etc.. now it has somehow been
changed to 1 , 2 , 3 ... 256

could anyone give me some idea how i can change it back ?

tks & rdgs
 
Tools > Options > General
Uncheck box for R1C1reference style

Mangesh
 
Hello Maxzsim,

Goto "Tools" --> "Option" --> tab "General" --> remove checkmark for "R1C1
reference style".

HTH,
CoRrRan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Headings 3
Alpha column lables 2
change Excel column headings from numbers to alpha characters 2
How do I change my column designator from Numeric to Alpha? 1
Excel Help to copy information from one row at a time to another sheet 1
Convert a letter to a numeric value 3
Alpha to Numeral column name 3
Excel XP. column headings are numeric I want alpha 1

Back
Top