ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Columns change from letters to numbers (https://www.excelbanter.com/excel-discussion-misc-queries/181368-columns-change-letters-numbers.html)

Ringo Ossie

Columns change from letters to numbers
 
I have been using excel 2003 for some months now & when i open saved files or
a new workbook my columns have changed from letters to numbers.
Why would this happen & how can i change it back.

Mike

Columns change from letters to numbers
 

Tools|Options|General
Unckeck the R1C1 reference style

"Ringo Ossie" wrote:

I have been using excel 2003 for some months now & when i open saved files or
a new workbook my columns have changed from letters to numbers.
Why would this happen & how can i change it back.


PCLIVE

Columns change from letters to numbers
 
Tools | Options | General |
Uncheck 'R1C1 reference style'

HTH,
Paul

--

"Ringo Ossie" <Ringo wrote in message
...
I have been using excel 2003 for some months now & when i open saved files
or
a new workbook my columns have changed from letters to numbers.
Why would this happen & how can i change it back.





All times are GMT +1. The time now is 10:04 PM.

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