ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I change my column designator from Numeric to Alpha? (https://www.excelbanter.com/setting-up-configuration-excel/189471-how-do-i-change-my-column-designator-numeric-alpha.html)

Jon

How do I change my column designator from Numeric to Alpha?
 
I have been using Excell for several years, but have never experienced my
recent quandry. My column which are normally designated by alpha characters
,"A, B, C..." are now being designated as numeric, "1, 2, 3..." Can someone
help to change them back?


Dave Peterson

How do I change my column designator from Numeric to Alpha?
 
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.

Jon wrote:

I have been using Excell for several years, but have never experienced my
recent quandry. My column which are normally designated by alpha characters
,"A, B, C..." are now being designated as numeric, "1, 2, 3..." Can someone
help to change them back?


--

Dave Peterson


All times are GMT +1. The time now is 09:55 AM.

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