ExcelBanter - why are my column headers numbers instead of letters?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - why are my column headers numbers instead of letters? (https://www.excelbanter.com/excel-discussion-misc-queries/261838-why-my-column-headers-numbers-instead-letters.html)

tbecks

why are my column headers numbers instead of letters?

It seems like overnight my spreadsheets changed from having letters as column
headers to having numbers. I'm sure it's something I've done wrong...can
anyone help me?

Eduardo

why are my column headers numbers instead of letters?

Hi,
Go to excel options and uncheck R1C1 reference style in excel 2007 is under
formulas

"tbecks" wrote:

It seems like overnight my spreadsheets changed from having letters as column
headers to having numbers. I'm sure it's something I've done wrong...can
anyone help me?

Jim Thomlinson

why are my column headers numbers instead of letters?

Tools - Options - General Tab - Uncheck R1C1 for XL2003 and earlier.
--
HTH...

Jim Thomlinson

"tbecks" wrote:

It seems like overnight my spreadsheets changed from having letters as column
headers to having numbers. I'm sure it's something I've done wrong...can
anyone help me?

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