PC Review


Reply
Thread Tools Rate Thread

How can I change column headers from numeric to alpha?

 
 
=?Utf-8?B?VHJpc2g=?=
Guest
Posts: n/a
 
      23rd Oct 2007
I have a spreadsheet where somehow the column headers got changed from alpha
to numeric. How can I change them back?
 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      23rd Oct 2007
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?


 
Reply With Quote
 
Ron Coderre
Guest
Posts: n/a
 
      23rd Oct 2007
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?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


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