Microsoft Excel: Enter 1-4-5 as Text Without Date Conversion
Question details
The user needs to enter 1-4-5 in a spreadsheet while keeping it as text instead of allowing automatic date conversion.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A value containing hyphens must remain exactly as entered for a label, code, or other text value.
- Observed behavior
- Excel may interpret 1-4-5 as a date and automatically change its formatting or stored value.
Select the target cell and check whether it is formatted as General or Date. If the value has already been converted, clear the cell before entering it again as text.
Add an apostrophe before 1-4-5
Use this quickest method when entering one or a few values that contain hyphens and must remain text.
A leading apostrophe tells Excel to store the following characters as text. The apostrophe is not displayed in the completed cell value.
Click the cell where you want to enter the value.
Enter an apostrophe followed by the value, exactly as '1-4-5.
Press Enter. The cell displays 1-4-5 and keeps it as text rather than converting it to a date.
Format the cell as Text before entering the value
Use this method when entering many hyphenated values or when an entire column should preserve entries as text.
Keep Hyphenated Values as Text in WPS Spreadsheet
WPS Spreadsheet can preserve entries such as 1-4-5 as text. Add an apostrophe for a single entry or set the cells to Text before entering a list of values.
- 1. Select the destination cell: Open WPS Spreadsheet and click the cell where you want to enter 1-4-5.
- 2. Enter an apostrophe: Type '1-4-5 into the cell, then press Enter to store the value as text.
- 3. Format a range when needed: For multiple entries, select the range, open the Home tab's Number Format menu, and choose Text before entering the values.
Frequently Asked Questions
Why does Excel change 1-4-5 into a date?
Excel recognizes hyphen-separated values as possible dates when the cell uses a general or date-compatible format. It may then display and store the entry as a date.
Does the apostrophe remain visible in the cell?
No. When you type '1-4-5, Excel uses the apostrophe as a text indicator and displays only 1-4-5 in the worksheet cell.
How can I keep a whole column of hyphenated values as text?
Select the column, open Home > Number Format, choose Text, and then enter or paste the values. Values that were already converted may need to be re-entered.
Can I use the same method in WPS Spreadsheet?
Yes. Type an apostrophe before the value, or select the cells and choose Home > Number Format > Text before entering the data.
