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

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

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
Column headers numbers instead of letters Hursh Excel Discussion (Misc queries) 2 September 9th 09 08:53 PM
column headers appear as numbers not letters John Perri Excel Discussion (Misc queries) 1 March 9th 09 03:55 PM
column headers changed from letters to numbers, how do I change ba B Lutz Excel Discussion (Misc queries) 1 April 27th 08 02:58 AM
Change Excel column headers from numbers to letters Dave Excel Discussion (Misc queries) 1 December 12th 07 02:47 PM
How to switch column headers from numbers back to letters? Measurement Consultant Excel Worksheet Functions 2 January 14th 06 03:30 PM


All times are GMT +1. The time now is 02:50 AM.

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

About Us

"It's about Microsoft Excel"