ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   column from ABC to 123 (https://www.excelbanter.com/excel-worksheet-functions/47684-column-abc-123-a.html)

chiuinggum

column from ABC to 123
 
Normally the column is name alphabetically example A, B, C but I dont know
what I did it was changed to numerical 1, 2, 3. How do I change it back to
A,B,C?

Anne Troy

Tools--Options, General tab. Uncheck R1C1 reference style.
************
Anne Troy
www.OfficeArticles.com

"chiuinggum" wrote in message
...
Normally the column is name alphabetically example A, B, C but I dont know
what I did it was changed to numerical 1, 2, 3. How do I change it back to
A,B,C?





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

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