ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column changed to numbers (https://www.excelbanter.com/excel-discussion-misc-queries/80943-column-changed-numbers.html)

mmurray

column changed to numbers
 

My column designations have changed from letters to numbers. I have no
idea why this happened. Is there a way to change this back?


--
mmurray
------------------------------------------------------------------------
mmurray's Profile: http://www.excelforum.com/member.php...o&userid=33064
View this thread: http://www.excelforum.com/showthread...hreadid=528780


L. Howard Kittle

column changed to numbers
 
Sorry, once it's like that there is nothing you can do!

Except Tools Options General Settings un-check R1C1 reference
setting.

HTH
Regards,
Howard

"mmurray" wrote in
message ...

My column designations have changed from letters to numbers. I have no
idea why this happened. Is there a way to change this back?


--
mmurray
------------------------------------------------------------------------
mmurray's Profile:
http://www.excelforum.com/member.php...o&userid=33064
View this thread: http://www.excelforum.com/showthread...hreadid=528780




Elkar

column changed to numbers
 
Tools -- Options -- General Tab

Uncheck the box for R1C1 Reference Style.

HTH,
Elkar


"mmurray" wrote:


My column designations have changed from letters to numbers. I have no
idea why this happened. Is there a way to change this back?


--
mmurray
------------------------------------------------------------------------
mmurray's Profile: http://www.excelforum.com/member.php...o&userid=33064
View this thread: http://www.excelforum.com/showthread...hreadid=528780




All times are GMT +1. The time now is 12:21 PM.

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