column headings display as numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JayT - 29 Nov 2004 18:09 GMT

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.

Reply to this Message

Paul B - 29 Nov 2004 18:24 GMT

Jay, don't know why it changed, to change it back tools, options, general,
and uncheck R1C1 reference style

Signature

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

> 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.

Reply to this Message

Gord Dibben - 29 Nov 2004 18:51 GMT

Tools>Options>General.

Uncheck "R1C1 reference style".

Gord Dibben Excel MVP

>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.

Reply to this Message

Rate this thread: