ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How could my column labels become numbers instead of letters??? (https://www.excelbanter.com/excel-discussion-misc-queries/192663-how-could-my-column-labels-become-numbers-instead-letters.html)

Ruth

How could my column labels become numbers instead of letters???
 
I am working on a finance document with about 40 columns by over 100 rows. I
don't know how but the column titles now read as numbers instead of letters.
I have tried beginning a new document with the same data, but this too has
now changed (overnight).
does anyone have any ideas how this occured??
Ruth

Dave Peterson

How could my column labels become numbers instead of letters???
 
In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks up this setting from the first workbook you open in that session.

Ruth wrote:

I am working on a finance document with about 40 columns by over 100 rows. I
don't know how but the column titles now read as numbers instead of letters.
I have tried beginning a new document with the same data, but this too has
now changed (overnight).
does anyone have any ideas how this occured??
Ruth


--

Dave Peterson

Ruth

How could my column labels become numbers instead of letters???
 
thankyou Dave, that worked

"Ruth" wrote:

I am working on a finance document with about 40 columns by over 100 rows. I
don't know how but the column titles now read as numbers instead of letters.
I have tried beginning a new document with the same data, but this too has
now changed (overnight).
does anyone have any ideas how this occured??
Ruth



All times are GMT +1. The time now is 12:05 AM.

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