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