4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included

4 quick and simple methods to use in Excel to convert a range of numbers that are stored as text to be stored as numbers. This is an important thing to know how to do when working with large data sets, especially when that data is imported into Excel from other programs or CSV files.

The methods show here will work on any version of Excel and should be considered key tools to memorize for any daily spreadsheet user.

[bmvgznt]

Your 4th scenario is a game changer, love it thank you so much, all other options were not working.

[MzChrisyKK]

Thank you for this video!!! I am working on a pricing sheets with all kinds of issues! This fixed one of the bigger ones for me...that text to columns....wow! WFH sure allows for great Youtube training! :)

[odiswhite]

Thanks so much for this video! I searched for hours today to find an easy way to convert a large set of Numbers stored as Text. I had downloaded a form with a spreadsheet containing 30 Columns and 80 rows with numbers stored as text. Your Fourth Solution of Space Special Multiplier by 1 for the whole spreadsheet did the trick in seconds!

[Pankaj-Verma-]

Great video~ Thank you so much for your kind help!

[TheLoquilla]

This is very very helpful! Thank you so much!!!

[DanniMortensen]

thanks alot for the help, i've been searching for an solution to this problem for so long. The text to columns solved it for me.

[adrianberechet]

Golden minute at 3:00. I fixed using text to columns. Thanks a lot!

[minaromany]

This is very Useful tutorial !
thank you for your tips
it makes our jobs easier ;)

[mdsalim]

Thank you so much. When i entry numeric via data entry form then it store as text. Now i solved this problem by your formula.

[wolfmanbfg]

Thank you so much it really solved my problem. . . .

[tylee]

2nd example was perfect - I was spending all kinds of time trying to figure out why the excel cell showed number but was acting as text ! Awesome - Thanks

[criscris]

If all steps are not working for you, check your number entry. There must be a single space in it. Just delete the space, most of the time it happens if you copy a number from another source.

[mirrrvelll]

Not only left for text or right for numbers but, if you align in center, then it's hard to see what text/number is. Ofc, it will be written in Number Formats, but people are not looking always... :D good video, decent.

[AV]

I'm an research engineer with experience processing data in Matlab, Mathematica, and many other more scientific software, and Excel is still a struggle to me. Why do I need to watch a tutorial on how to import data from a file?
Thanks to TeachExcel for the video.

[AUDIOMIND]

What is the fastest method for changing multiple columns of dynamic data into numbers?

[hedyelizabeth]

It just happens that I was struggling with a match formula issue today.  However, I am matching one column with another column that both contain two integers and two letters (in caps).  Ex: 04TT in cell A2 and 04TC in cell B2.  The match formula did not recognize that these are different.  I ended up just doing a simple  =A2=B2. I tried to figure out how to fix this via formatting, but was unsuccessful.  Do you have any thoughts by any chance on how I could format this differently.

[steveistheman]

I ended up c/p'ing into an html editor and using the multi-line select (alt+left-click)

[ahmadyani_]

I'm working with 16-digit numbers. I tried all your methods, but all last digits were changed to 0, not the number it supposed to be. Would you please help me with this? Thanks a lot.

[mihakopac]

How to convcert text for example 93, 3 to number? Text to column function doesnt work, or only work if you want to cut commas away..

What if we have 0's in front and we don't want it to go away when we convert it into a value