Use Alt+DEF to convert a column of text to numbers.
Transcript of the video:
Learn Excel From MrExcel, Podcast Episode 2143: ALT+D, E, F To Convert Numbers Stored As Text To Real Numbers.
Alright, so, here I have a VLOOKUP formula.
VLOOKUP formula is looking for 11,000 in this table and it is saying it can't be found, which is wrong.
It should be able to be found.
These, though, are stored as numbers, these are stored as text.
I need to convert these quickly from text numbers to numbers, and, yes, I could grab the mouse and come all the way up here and hover and click the arrow and choose CONVERT TO NUMBER, but it's just faster.
Hold down ALT+D, E, F and it will quickly convert those text numbers to numbers.
What are we doing in there?
We’re doing DATA, TEXT TO COLUMNS, FINISH, and that solves the problem.
ALT+D, E, F: a fast way to solve that problem.
Thanks for stopping by.
We’ll see you next time for another netcast from MrExcel.
Alright, so, here I have a VLOOKUP formula.
VLOOKUP formula is looking for 11,000 in this table and it is saying it can't be found, which is wrong.
It should be able to be found.
These, though, are stored as numbers, these are stored as text.
I need to convert these quickly from text numbers to numbers, and, yes, I could grab the mouse and come all the way up here and hover and click the arrow and choose CONVERT TO NUMBER, but it's just faster.
Hold down ALT+D, E, F and it will quickly convert those text numbers to numbers.
What are we doing in there?
We’re doing DATA, TEXT TO COLUMNS, FINISH, and that solves the problem.
ALT+D, E, F: a fast way to solve that problem.
Thanks for stopping by.
We’ll see you next time for another netcast from MrExcel.
