EXCEL converting text to numbers

Posted on 2011-10-13
Last Modified: 2012-06-27
I need a quick solution to this.
I have a large EXCEL 2010 spreadsheet imported from a pdf file which contain a large amount of numbers stored as text.
Is there a quick way to select this numeric text and turn it into numbers?
Selecting a range of cells and choosing format cells does not appear to work.
I know it can be done cell by cell but this would take forever.
Question by:CharlesOrr
    LVL 4

    Accepted Solution

    Hhmm... it should work the way you tried.

    A couple of ideas:

    1. when Excel shows the error "Number stored as text", there's a menu there that you can open and specify "ignore". This can be done for many cells at a time.

    2. Check if your numbers are really numbers that Excel can understand. They should have no symbols or letters. One that sometimes slips through is a "." dot instead of a "," comma for decimals. These must match what you have defined in your Windows regional options.
    LVL 33

    Expert Comment

    Did you tryed selecting all of the cells and Copy + Paste Special only Values into a new blank sheet?

    Author Closing Comment

    Hi Pgrod
    I'd missed the fact the that the menu appeared for all highlighted cells.
    You can select 'convert to numbers'.
    You made me look a little further so you are welcome to the points.
    Thank you very much.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Viewers will learn how to find and create templates in Excel 2013.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now