Ask Experts Questions for FREE Help !
Ask
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #1

    Jun 29, 2009, 07:55 AM
    Numbers Instead Of Letters in My Columns
    I have a problem with my excel because it's displaying numbers in columns headers instead of letters. Do you know how can I fix this problem?
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
    		  
    #2

    Jun 29, 2009, 07:58 AM
    Can you explain a little more clearly what you mean? Did you enter letters and they're showing up as numbers? What did you enter and what are you seeing?

    You can select the column and select "Format Cells". You can then change the formatting to suit your needs.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Jun 29, 2009, 08:13 AM

    Click on TOOLS > OPTIONS > GENERAL > [ ] R1C1 reference style

    ... uncheck that option.


    Your explanation was clear enough. (wink)
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #4

    Jun 29, 2009, 08:17 AM
    Numbers Instead Of Letters in My Columns
    Maybe if I send you a screen shoot it would be more clear. In the file attached you will find one screen shoot of my excel and you will find that the rows marked with red have numbers (This is OK), but you will also find that the columns marked with red have also numbers instead of letters (As excel normally displayed them).
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #5

    Jun 29, 2009, 08:30 AM
    Numbers Instead Of Letters in My Columns
    Hi JB,

    Thanks for your feedback. And for Microsoft Excel 2007 how can I reach the option described in your response??
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #6

    Jun 29, 2009, 08:33 AM

    Well, when I Google "Excel 2007 R1C1 reference style" the first link says:

    How to Switch A1 and R1C1 Reference Style in Excel?

    In Office 2007, click the Office button and click Excel Options which you will find at the end near Exit Excel.

    Go to Formulas tab and under Working with formulas, check or uncheck R1C1 reference style to use it or to change it to A1 reference style.
    Alejandro Sanchez's Avatar
    Alejandro Sanchez Posts: 16, Reputation: 1
    New Member
    		  
    #7

    Jun 29, 2009, 08:38 AM
    Hi JB,

    You are great!! Thanks for your support.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Can't type letters. They appear as numbers [ 5 Answers ]

I have a big problem! When I try to type, some letters appear as nubmers. This only happens to letters that have a number underneath. The other letters appear just fine! But I can't type a full word, nor a sentence! Please help me!

Keyboard keys type numbers not letters [ 3 Answers ]

Trying to correct the keyboard typing the numbers under the letters. Help

Letters are numbers and num lock off no numbers [ 2 Answers ]

I cannot get my hp pavilion notebook to respond, it started all of a sudden. When my num lock is on my letters on the keyboard turn into numbers... I=5 and so forth. Now when my num lock is off my keyboard works fine but I cannot use the number pad. I tried the fn key with almost every key on the...

Numbers displaid instead of letters on web pages [ 1 Answers ]

Why do some web pages display numbers instead of letters? What can I do to be able to read page?

Multiple numbers and Letters [ 1 Answers ]

I have Windows XP and when I go to miniclips.com, the home page is full of Huge blue numbers and letters and looks like 5 or 6 pages of info is jumbled together. I asked someone to see if the miniclip home page looked the same to them and they checked and said it looked OK. What could be my...

View more questions Search