EXCEL converting text to numbers

Hi
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.
regards
Charles
CharlesOrrAsked:
Who is Participating?
 
pgorodConnect With a Mentor Commented:
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.
0
 
jppintoCommented:
Did you tryed selecting all of the cells and Copy + Paste Special only Values into a new blank sheet?
0
 
CharlesOrrAuthor Commented:
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.
regards
Charles
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.