columns changing to numbers

P

Pablo

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
 
M

Myrna Larson

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".
 
T

Trevor Shuttleworth

Pablo

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

Regards

Trevor
 
Top