[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


EXCEL converting text to numbers

Posted on 2011-10-13
Medium Priority
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

Accepted Solution

pgorod earned 2000 total points
ID: 36961599
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

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

Author Closing Comment

ID: 36962004
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.

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

873 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