ExcelBanter - Column and Row labels are numeric

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Column and Row labels are numeric (https://www.excelbanter.com/excel-worksheet-functions/221400-column-row-labels-numeric.html)

TJtheDJ

Column and Row labels are numeric

Both my column and row labels are numeric. Example: cell A1 is now R1C1.
How can I get the column back to alpha?

Dave Peterson

Column and Row labels are numeric

In xl2003:
Tools|Options|General tab|uncheck R1C1 reference style

TJtheDJ wrote:

Both my column and row labels are numeric. Example: cell A1 is now R1C1.
How can I get the column back to alpha?

--

Dave Peterson

JBeaucaire[_90_]

Column and Row labels are numeric

Tools Options General [ ] R1C1 Reference style

Uncheck that.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.

"TJtheDJ" wrote:

Both my column and row labels are numeric. Example: cell A1 is now R1C1.
How can I get the column back to alpha?

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