Results 1 to 7 of 7

Thread: Text is shown as General in excel 2010

  1. #1

    Text is shown as General in excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    When I enter a text, say "Programming", Excel shows it as general instead of a text. Why please?

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    If you look at General format on the Home ribbon, it indicates ABC 123 no specific format.
    Text is a specific format.

  3. #3
    So when it changes to show a text or number? Whatever number (say 12) or text I enter, they are all shown as General! Isn't it odd?

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Isn't it odd?
    No, I don't think so.
    That 12 you entered, was it 12 o'clock or 12 dollars, or did you want 6 decimal points with it?
    Not knowing, Excel gives you its' best guess, which is exactly what you entered.
    It's up to you if you need to be more specific.

  5. #5
    this is interesting (I am posting this because looks like I need 5 posts before I can attach a file or post a link)

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    ladygaga,

    Please don't post these kinds of posts. Make 5 legitimate posts and you can add your links. Or PM Administrators to discuss options.

    Thanks for your cooperation.


  7. #7
    @No s: So when Excel changes that format to text or number? For example, what text or what number I need to enter so that Excel recognizes it as text/number?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •