ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Numerical Column Headers (https://www.excelbanter.com/excel-discussion-misc-queries/178382-excel-2007-numerical-column-headers.html)

Excel 2007 numeric column headers

Excel 2007 Numerical Column Headers
 
My column headers are showing as numeric instead of alphabetic - the only
help I can find online is pre-2007...where's the setting for 2007? Functions
are now EXTEMELY unintuitive...

Tyro[_2_]

Excel 2007 Numerical Column Headers
 
Office Button/Excel Options/Formulas/Working with formulas - uncheck R1C1
Reference Style

Tyro

"Excel 2007 numeric column headers" <Excel 2007 numeric column
wrote in message
...
My column headers are showing as numeric instead of alphabetic - the only
help I can find online is pre-2007...where's the setting for 2007?
Functions
are now EXTEMELY unintuitive...




Tyro[_2_]

Excel 2007 Numerical Column Headers
 
Excel 2007 did not check that for you. Some human being did. You?

Tyro

"Tyro" wrote in message
...
Office Button/Excel Options/Formulas/Working with formulas - uncheck R1C1
Reference Style

Tyro

"Excel 2007 numeric column headers" <Excel 2007 numeric column
wrote in message
...
My column headers are showing as numeric instead of alphabetic - the only
help I can find online is pre-2007...where's the setting for 2007?
Functions
are now EXTEMELY unintuitive...






Excel 2007 numeric column headers[_2_]

Excel 2007 Numerical Column Headers
 
Not unless somebody at work messed with my computer (which is possible). If
it's set up that way for a particular spreadsheet that I open, will it check
it?

(it worked by the way - Thanks!)

"Tyro" wrote:

Excel 2007 did not check that for you. Some human being did. You?

Tyro

"Tyro" wrote in message
...
Office Button/Excel Options/Formulas/Working with formulas - uncheck R1C1
Reference Style

Tyro

"Excel 2007 numeric column headers" <Excel 2007 numeric column
wrote in message
...
My column headers are showing as numeric instead of alphabetic - the only
help I can find online is pre-2007...where's the setting for 2007?
Functions
are now EXTEMELY unintuitive...







Tyro[_2_]

Excel 2007 Numerical Column Headers
 
No, R1 C1 Reference Style is Excel level, not workbook level. If if were a
workbook/worksheet option, Excel would state so.

Tyro

"Excel 2007 numeric column headers"
ft.com wrote in message
...
Not unless somebody at work messed with my computer (which is possible).
If
it's set up that way for a particular spreadsheet that I open, will it
check
it?

(it worked by the way - Thanks!)

"Tyro" wrote:

Excel 2007 did not check that for you. Some human being did. You?

Tyro

"Tyro" wrote in message
...
Office Button/Excel Options/Formulas/Working with formulas - uncheck
R1C1
Reference Style

Tyro

"Excel 2007 numeric column headers" <Excel 2007 numeric column
wrote in message
...
My column headers are showing as numeric instead of alphabetic - the
only
help I can find online is pre-2007...where's the setting for 2007?
Functions
are now EXTEMELY unintuitive...









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

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