Formatting Issues

Enter Negative Number Ranges as Text in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 870 views

Question details

The user needs to enter a range between two negative numbers as text in Excel.

Enter Negative Number Ranges as Text in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Entering a range such as -1--0.5 in a worksheet cell.
Observed behavior
Excel may interpret the entry as a formula and calculate it instead of displaying the intended range.
Before you start

Choose the cell or cells where you want the range to appear. If Excel has already calculated an entry, you will need to re-enter the range after changing the cell format.

Solution 1Recommended

Format the Excel Cell as Text Before Entering the Range

Use Text formatting when you plan to enter one or more negative number ranges in selected cells.

1
Select the cells

In the worksheet, select the cell or cells where you want to enter the ranges.

2
Apply Text formatting

Right-click the selection, choose Format Cells, select Text under Number, and click OK.

3
Enter the range

Type -1--0.5 into a formatted cell and press Enter. Excel should display the range as text rather than calculate it.

Format the Excel Cell as Text Before Entering the Range
Re-enter existing values: Changing the format alone does not restore a range that Excel has already calculated. Type the intended range again in the formatted cell.
Use WPS Spreadsheets

Enter Negative Number Ranges as Text in WPS Spreadsheets

Use Text formatting in WPS Spreadsheets to display a negative number range without calculating it.

  1. 1. Open your workbook: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Format the target cell: Select the cell, right-click it, and choose Format Cells. Select Text under Number and confirm.
  3. 3. Enter the range: Type -1--0.5 in the formatted cell and press Enter.
  4. 4. Save the workbook: Choose Save or Save As to keep the entry in your workbook.
Display negative number ranges as text in worksheet cellsOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formatting controlsWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel calculate my negative number range?

An entry beginning with a minus sign can be interpreted as a formula. Format the cell as Text before entering the range, or put an apostrophe immediately before it.

Will the leading apostrophe show in the worksheet?

No. Entering '-1--0.5 displays -1--0.5 in the worksheet; the apostrophe tells Excel to treat the entry as text.

Can I fix a range that Excel has already calculated?

Yes. Right-click the cell, choose Format Cells, select Text, and then re-enter the intended range. Changing the format alone will not restore the original entry.

Can I use a text-formatted range directly in calculations?

No. A range such as -1--0.5 is stored as text, not as two numeric values. Enter the endpoints in separate numeric cells if you need to calculate with them.