ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   A:1 now R1C1 (https://www.excelbanter.com/excel-worksheet-functions/61826-1-now-r1c1.html)

Michael E W

A:1 now R1C1
 
My columns have suddenly appeared with numero's instead of lettero's.

Not sure if I did something or what may be up. Any feedback would be
appreciated.


A:1 now R1C1
 
Hi

Go to Tools/Options/General and untick R1C1 reference style.

Andy.

"Michael E W" wrote in message
...
My columns have suddenly appeared with numero's instead of lettero's.

Not sure if I did something or what may be up. Any feedback would be
appreciated.




Michael E W

A:1 now R1C1
 
Thank You. I can only assume it was the operator.

"Andy" wrote:

Hi

Go to Tools/Options/General and untick R1C1 reference style.

Andy.

"Michael E W" wrote in message
...
My columns have suddenly appeared with numero's instead of lettero's.

Not sure if I did something or what may be up. Any feedback would be
appreciated.






All times are GMT +1. The time now is 02:25 AM.

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