MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column Heading is all Numbers, not Alpha


Posted by Oscar on January 11, 2002 6:31 PM

Opened an older spreadsheet in Excel 2000. The column headings are all 1,2,3, etc. rather than the usual A,B,C, etc. Obviously the formulas don't work now. Can't figure out how this happened, or how to change back. Help Please!

Oscar


Posted by Jacob on January 11, 2002 7:15 PM

Hi


Options|General Then uncheck R1C1 style references

HTH

Jacob