Master Excel with our tips, tricks & tools!
Subscribe to our Free Email Newsletter

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.

  1. 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.Number Stored as Text Error
    _
  2. 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
    _
  3. 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

Excel Convert Text to Number Keyboard Shortcut Alt+Menu Key+C_

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.

Keyboard Diagram Menu Key Windows_

Alternative Methods

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.

If you enjoyed this article, subscribe to our free newsletter!

Thank you, your sign-up request was successful! Please check your e-mail inbox.
Given email address is already subscribed, thank you!
Please provide a valid email address.
Oops. Something went wrong. Please try again later.

2 Responses to Convert Text to Numbers – Excel Keyboard Shortcuts

  1. Don says:

    Fantastic. The simple answer seems to be the most efficient and easy to use. I recorded a macro to use text to column, choosing delimited, no boxes checked for format. Works well for a contiuous range in a column, but this video is great for ease of use.

    • Jon says:

      Thanks Don! Macros can be great for automating a repetitive process. And I’m glad you found this useful.

Please leave a comment

Subscribe without commenting