ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   column headings display as numbers (https://www.excelbanter.com/setting-up-configuration-excel/4947-column-headings-display-numbers.html)

JayT

column headings display as numbers
 
Excel has suddenly begun to display all column headings as numbers instead of
letters. Does anyone know why, but more to the point, how to change it back
to letters? Thanks.

Paul B

Jay, don't know why it changed, to change it back tools, options, general,
and uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JayT" wrote in message
...
Excel has suddenly begun to display all column headings as numbers instead
of
letters. Does anyone know why, but more to the point, how to change it
back
to letters? Thanks.




Gord Dibben

ToolsOptionsGeneral.

Uncheck "R1C1 reference style".

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 10:09:53 -0800, "JayT"
wrote:

Excel has suddenly begun to display all column headings as numbers instead of
letters. Does anyone know why, but more to the point, how to change it back
to letters? Thanks.




All times are GMT +1. The time now is 10:42 PM.

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