New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Numbers stored as text

Google Sheets · Verified tutorial

Numbers stored as text in Google Sheets

The values in A2:A4 are stored as text. Convert them to real numbers without changing their visible values or order.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

The values in A2:A4 are stored as text. Convert them to real numbers without changing their visible values or order.

Step-by-step

1

Select the targetThe values in A2:A4 are stored as text.

2

Apply the changeConvert them to real numbers without changing their visible values or order.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A4 contains the numeric values 10, 25, and 40.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A2:A4 and repeat the final action. A2:A4 contains the numeric values 10, 25, and 40.

Example spreadsheet data

This is the clean fixture used for the verified run.

Amount

10

25

40

Video transcript

Open the prepared Number repair spreadsheet.
Select the target. The values in A2:A4 are stored as text.
Apply the change. Convert them to real numbers without changing their visible values or order.
A2:A4 contains the numeric values 10, 25, and 40.