Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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...



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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...





  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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...






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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...







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you identify the first row as headers in EXCEL 2007? ljt Excel Discussion (Misc queries) 7 November 15th 07 04:11 PM
Numeric column headers Excel 2007 Dale M Warehime Excel Discussion (Misc queries) 2 June 14th 06 10:11 PM
Excel 2007 worksheet headers do not print Sabrina Excel Worksheet Functions 1 June 12th 06 04:28 PM
Excel - returning column headers in a seperate column ExcelConfused Excel Discussion (Misc queries) 1 March 28th 06 02:49 PM
In Excel, COLUMN HEADERS ARE NUMERICAL dstach11 Excel Discussion (Misc queries) 3 December 23rd 04 06:01 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"