columns changing to numbers

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

Guest

I opened a worksheet this afternoon and found that the column headings have
changed from alpha characters to numerals. Now all my worksheets are
reflecting numerals in the columns.

Has anyone seen this before or know what I can do to fix it?

Thanks,
Pablo
 
You probably didn't look at your formulas. If you did, you'd be even more
distressed. Go to Tools/Options/General and uncheck "R1C1 Reference Style".
 
Pablo

Tools | Options | General tab | Settings section | switch off R1C1 reference
style

Regards

Trevor
 
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

How do i change column header from R[1] C format to A1 format? 4
Column and Row Labels 1
Alpha to Numeral column name 3
How: reset the column headings from numeric to alphabetic? 1
Worksheet has numeric column headings. Change to alpha headings? 1
Change the column designation from a numeric to an alpha 2
Excel 2007... fix column headings from numbers back to letters 4
How do change excel columns from alphabetic to numeric 1

Back
Top