How can I change column headers from numeric to alpha?

's Computer Specifications

I have a spreadsheet where somehow the column headers got changed from alpha
to numeric. How can I change them back?

's Computer Specifications

Tools>Options>General tab, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Trish" <(E-Mail Removed)> wrote in message news:F69B3F39-5EE7-4CD5-B4D0-(E-Mail Removed)...
|I have a spreadsheet where somehow the column headers got changed from alpha
| to numeric. How can I change them back?

's Computer Specifications

From the Excel Main Menu:
<tools><options><general tab>...UNcheck: R1C1 reference style.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Trish" <(E-Mail Removed)> wrote in message news:F69B3F39-5EE7-4CD5-B4D0-(E-Mail Removed)...
>I have a spreadsheet where somehow the column headers got changed from alpha
> to numeric. How can I change them back?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change my column designator from Numeric to Alpha?	Jon	Microsoft Excel Setup	1	30th May 2008 08:59 PM
How can I change my column references from Alpha to Numeric?	=?Utf-8?B?RGFuZWxsZSBCb2xpbmcsIFNhbGVzIEFuYWx5c3Q=	Microsoft Excel Worksheet Functions	1	15th Aug 2006 07:45 PM
Change the column designation from a numeric to an alpha	=?Utf-8?B?R2VvcmdlIFNsYWRreQ==?=	Microsoft Excel Misc	2	4th May 2006 02:47 PM
change excel auto column headers from numeric to alpha	=?Utf-8?B?TWFyY2llaW5IYXdhaWk=?=	Microsoft Excel Misc	2	14th Feb 2006 09:22 PM
Column headers displays NUMERIC value instead of alpha	Mr. Vern	Microsoft Excel Setup	2	12th Jul 2004 08:22 PM