ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   columns changing to numbers (https://www.excelbanter.com/excel-discussion-misc-queries/16169-columns-changing-numbers.html)

Pablo

columns changing to numbers
 
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

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

On Fri, 4 Mar 2005 14:49:02 -0800, "Pablo"
wrote:

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



Trevor Shuttleworth

Pablo

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

Regards

Trevor


"Pablo" wrote in message
...
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





All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com