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.

Please share this post:
Please share
Jon Acampora

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 11 comments
Parveen - July 7, 2015

thank you so much, really it is very simple, i searched lot of websites but could not find answer,

Garveet - June 21, 2014

We can also use the paste special. (source: microsoft website)

To use the Paste Special command, follow these steps:
In any blank cell, type the value 1.
Make sure the cell you typed 1 in is formatted as a number.
Select the cell in which you typed 1, and then right click and choose Copy.
Select the cells with the values that you want to convert to numbers.
Right click and choose Paste Special.
Under Operation, click Multiply and then click OK.

    Jon Acampora - July 1, 2014

    Hi Garveet,

    That is a great suggestion! You can also use my new add-in, Paste Buddy, for this. With Paste Buddy you can create custom keyboard shortcuts for any of the paste special commands like paste values and paste formatting. You can also setup a keyboard shortcut for any of the paste operations like Add or Multiply.

    Checkout the following link to try Paste Buddy.


    Thanks again for this suggestion!

Veronica - June 19, 2014

Thank you for this tip – it is pretty effective. I’ve noticed that you can only access the Convert To Number menu from the upper left selected cell, this gets a bit frustrating when it is a large group and the process of selection causes the menu to scroll off the main page. Any hints on how to handle this?

    Jon Acampora - June 20, 2014

    Hi Veronica,
    Great question! After you have selected your large range of cells, try pressing the keyboard shortcut Ctrl+period(.) Hold the Ctrl key, then press the period(.) key.

    Ctrl+period activates the cells in each corner of the current selection in a clockwise motion. So let’s say you have selected the range A1:G20, and A1 is the active cell (meaning it is white and the other selected cells are shaded blue). Pressing Ctrl+period will activate the top-right cell of the selection (G1). Pressing Ctrl+period again will activate the bottom-right cell (G20). Press it again to activate the bottom-left cell (A20). And again to activate the top-left cell (A1).

    This will still keep the range selected, while just activating and scrolling to the cells in the corners.

    I use this shortcut all the time after I have pasted into a large area, and I want to make sure I didn’t paste over existing data, while still keeping the pasted range selected. It’s a lot faster than scrolling with the mouse!

    I hope the explanation is clear. I will make a video on this technique.

    Please let me know if you have any questions. Thanks!

Don - May 6, 2013

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 Acampora - May 8, 2013

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


Leave a Reply:

Take Your Excel Skills & Career to the Next Level

10 Excel Pro Tips eBook

Get my eBook & FREE weekly updates to help you learn Excel.