How to Change Text to Numbers in Excel

Advanced 30 min 13 steps 2495 views Rating: 3.8/5 Published: 2026-04-13

Open the Excel spreadsheet you want to edit.. Right-click the cell you want to edit.. Click Format Cells on the right-click menu.

Start Playback
E
Author

Steps

1

Open the Excel spreadsheet you want to edit.

Step 1

Open the Excel spreadsheet you want to edit.

2

Right-click the cell you want to edit.

Step 2

Right-click the cell you want to edit.

3

Click Format Cells on the right-click menu.

Step 3

Click Format Cells on the right-click menu.

4

Select Number in the Category panel.

Step 4

Select Number in the Category panel.

5

Select the decimal places you want to use (optional).

Step 5

Select the decimal places you want to use (optional).

6

Select a display format for negative numbers (optional).

Step 6

Select a display format for negative numbers (optional).

7

Click OK.

Step 7

Click OK.

8

Open Excel on your phone or tablet.

Step 8

Open Excel on your phone or tablet.

9

Open the spreadsheet you want to edit.

Step 9

Open the spreadsheet you want to edit.

10

Tap the cell you want to edit.

Step 10

Tap the cell you want to edit.

11

Tap the A icon at the top.

Step 11

Tap the A icon at the top.

12

Scroll down and tap Number Format.

Step 12

Scroll down and tap Number Format.

13

Select Number on the Number Format menu.

Step 13

Select Number on the Number Format menu.

View as Slideshow

Rate This Guide

★ ★ ★ ☆ ☆ 3.8/5
3

Comments (0)

No comments yet. Be the first to share your thoughts!