Convert Text to Numbers – Excel Keyboard Shortcuts
Excel has a built-in feature to convert text to numbers, but it can be tricky to use when you are trying to select a long list of cells or multiple rows and columns. In the video below I describe how to use keyboard shortcuts to accomplish this very quickly.
Keyboard Shortcuts to Convert Text to Numbers
Here’s a quick guide for the keyboard shortcuts to select the range of cells you want to convert.
- Select any cell that contains the Number Stored as Text error. You will see a small green triangle in the top left corner of the cell.
- Use the following keyboard shortcuts to select the range:
Ctrl + A – selects the entire contiguous range
Ctrl + A Twice – selects the entire sheet
Ctrl + Space bar – selects the entire column
Shift + Left/Right Arrow – selects multiple columns
Shift + Space bar – selects the entire rowShift + Up/Down Arrow – selects multiple rows
- The error menu drop-down will now be at the top left or right corner of your selected range. You can then use the following keyboard shortcut to Convert to Numbers.
Alt + Menu Key + C – Convert to Number
The Menu Key is located between the Alt and Ctrl keys on the right side of the keyboard. If your keyboard does not have a menu key, you can use Shift +F10 as an alternate.
I find the built-in feature to be the fastest, but there are other ways to accomplish this task:
- Copy a cell containing a 1 and Paste Special>Multiple on the range you want to convert.
- Use Text to Columns tool on the Data tab (ribbon). This is limited to one column and doesn’t work on rows.
- Functions – the VALUE() function works well, but there are many ways to do this too.
- VBA/Macro – write your own code to automate the process
Do you have a different or easier way? Please leave a comment.Please share this post:
Join Us & Learn Excel
Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.
Download the eBook
Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.
This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...