Enter Negative Number Ranges as Text in Excel
Question details
The user needs to enter a range between two negative numbers 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.
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.
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.
In the worksheet, select the cell or cells where you want to enter the ranges.
Right-click the selection, choose Format Cells, select Text under Number, and click OK.
Type -1--0.5 into a formatted cell and press Enter. Excel should display the range as text rather than calculate it.

Use an Apostrophe to Enter a Range as Text
Use a leading apostrophe for a quick, one-cell entry without changing the cell format first.
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. Open your workbook: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Format the target cell: Select the cell, right-click it, and choose Format Cells. Select Text under Number and confirm.
- 3. Enter the range: Type -1--0.5 in the formatted cell and press Enter.
- 4. Save the workbook: Choose Save or Save As to keep the entry in your workbook.

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.




