Missing the Green Arrow, top left corner to change text to number
Results 1 to 4 of 4

Thread: Missing the Green Arrow, top left corner to change text to number
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Missing the Green Arrow, top left corner to change text to number

    So this one is weird. We download into excel from a website and my co-worker doesn't have the green arrow in the top corner to be able to change the text to numbers. If she sends me the spreadsheet, or I download it myself, I can do it, but it never comes up on her machine, so she can't do subtotals or anything because her excel is still reading it as text instead of a number. Is there a setting or something we need to change on her machine to get the option?

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,841
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Missing the Green Arrow, top left corner to change text to number

    Goto File > Options > Formulas > under "Error checking rules" select "Numbers formatted as text" > Ok
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Jun 2006
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing the Green Arrow, top left corner to change text to number

    Perfect!! Thank you so much.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,841
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Missing the Green Arrow, top left corner to change text to number

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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