PC Review


Reply
Thread Tools Rating: Thread Rating: 4 votes, 4.00 average.

Column headings are numbers instead Alphabet Letters

 
 
Foremost19
Guest
Posts: n/a
 
      15th Jul 2009
I currently use Excel 2003. when I opened it, I noticed the column headings
showing the numbers same as the row heading numbers. Is there anyway for me
to fix this problem?
--
J
 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      15th Jul 2009
Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Foremost19" <(E-Mail Removed)> wrote in message
news:90054772-DB6F-4763-97F8-(E-Mail Removed)...
>I currently use Excel 2003. when I opened it, I noticed the column
>headings
> showing the numbers same as the row heading numbers. Is there anyway for
> me
> to fix this problem?
> --
> J


 
Reply With Quote
 
 
 
 
Nirmal
Guest
Posts: n/a
 
      11th Sep 2010
Sponsored by www.mastsale.com

Go to excel options in excel tab at left top most corner.Select Formulaes>Working with formulae>r1c1 reference style to correct to alphabets.

> On Wednesday, July 15, 2009 4:50 PM Foremost19 wrote:


> I currently use Excel 2003. when I opened it, I noticed the column headings
> showing the numbers same as the row heading numbers. Is there anyway for me
> to fix this problem?
> --
> J



>> On Wednesday, July 15, 2009 5:16 PM Niek Otten wrote:


>> Tools>Options>General tab, uncheck R1C1 Reference style
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel



>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>> A Comparison of Managed Compression Algorithms
>> http://www.eggheadcafe.com/tutorials...lgorithms.aspx

 
Reply With Quote
 
Keshava Prakash
Guest
Posts: n/a
 
      11th Jan 2011
Go to Tools>Options>General>Settings and uncheck "R1C1 reference style.

> On Wednesday, July 15, 2009 4:50 PM Foremost19 wrote:


> I currently use Excel 2003. when I opened it, I noticed the column headings
> showing the numbers same as the row heading numbers. Is there anyway for me
> to fix this problem?
> --
> J



>> On Wednesday, July 15, 2009 5:16 PM Niek Otten wrote:


>> Tools>Options>General tab, uncheck R1C1 Reference style
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel



>>> On Saturday, September 11, 2010 3:04 AM Nirmal wrote:


>>> Sponsored by www.mastsale.com
>>>
>>>
>>>
>>> Go to excel options in excel tab at left top most corner.Select Formulaes>Working with formulae>r1c1 reference style to correct to alphabets.



>>> Submitted via EggHeadCafe
>>> JSONP AJAX and ASP.NET Demystified
>>> http://www.eggheadcafe.com/tutorials...mystified.aspx

 
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
Why are column headings numbers instead of letters? Sally Sue Microsoft Excel Misc 1 18th Feb 2008 07:28 PM
my column headings are numbers instead of letters.how do i fix =?Utf-8?B?dGltZmluZXJhbkBtc24uY29t?= Microsoft Excel Misc 1 27th Aug 2007 07:06 PM
Using Row headings instead of Column Headings with DoCmd.TransferSpreadsheet rblivewire@hotmail.com Microsoft Access External Data 12 7th Jan 2007 08:07 PM
Column Headings showing numbers instead of letters =?Utf-8?B?U2FuZHkgTQ==?= Microsoft Excel Misc 2 8th Nov 2006 01:04 AM
why are my column headings numbers instead of letters? =?Utf-8?B?c2FyYWI=?= Microsoft Access 3 24th Aug 2005 06:38 PM


Features
 

Advertising
 

Newsgroups
 


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