Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
adel
 
Posts: n/a
Default How do I change column label from number to letter?

Hi,

Usually, the rows are numbers and the colums letters. Right now, my columns
are numbers also. How can I get it fixed because this is really confusing for
formulas.
Thank you.
  #2   Report Post  
CLR
 
Posts: n/a
Default

Tools Options GeneralTab..........uncheck the R1C1 reference style
box.............

Vaya con Dios,
Chuck, CABGx3



"adel" wrote in message
...
Hi,

Usually, the rows are numbers and the colums letters. Right now, my

columns
are numbers also. How can I get it fixed because this is really confusing

for
formulas.
Thank you.



  #3   Report Post  
Leith Ross
 
Posts: n/a
Default


Hello Adel,

On the Excel Toolbar select: Tools | Options | General (tab) | Settings
| R1C1 Reference Style (check box)

Click the Check Box. The Check Mark will disappear. Click OK and your
Columns will display letters again instead of numbers.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=381396

  #4   Report Post  
Michael
 
Posts: n/a
Default

Hi Adel. Go to Tools - Options and on the General Tab, deselect "R1C1"
reference style. HTH
--
Sincerely, Michael Colvin


"adel" wrote:

Hi,

Usually, the rows are numbers and the colums letters. Right now, my columns
are numbers also. How can I get it fixed because this is really confusing for
formulas.
Thank you.

  #5   Report Post  
Anne Troy
 
Posts: n/a
Default

Tools--Options--General tab. Untick R1C1 reference style.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"adel" wrote in message
...
Hi,

Usually, the rows are numbers and the colums letters. Right now, my

columns
are numbers also. How can I get it fixed because this is really confusing

for
formulas.
Thank you.





  #6   Report Post  
adel
 
Posts: n/a
Default

Thanks everyone. You were very helpful.

Adeline
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
chart label reference based on the column number z.entropic Charts and Charting in Excel 2 May 21st 05 05:54 PM
chart label reference based on the column number bj Charts and Charting in Excel 0 May 20th 05 07:18 PM
Change Text to a number jennifer Excel Worksheet Functions 1 April 27th 05 08:47 PM
How do I change the category axis number formatting in a Pivot Ch. Cultcab Charts and Charting in Excel 0 April 19th 05 12:26 AM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM


All times are GMT +1. The time now is 05:38 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"