Can't save numbers and words in excel.

Question

When a number and word is put in a specific cell on a excel worksheet it not saving it. When you try to save it the word goes away and the number move to the far right of the cell with sometimes part of the number missing.

Answer 1

It happens when the cell is formatted as Number, so Excel removes text and aligns the value to the right.

Try to select the affected cells, go to Home, then Number Format, and choose Text before entering your data.

It can keep both words and numbers exactly as typed. You can also type an apostrophe at the start of the entry, for example '123abc, so Excel treats it as text and does not alter it.

Answer 2

Excel is automatically interpreting the entry as a number (or date/scientific value) instead of text, so the text part is dropped and the number is right‑aligned and sometimes reformatted.

To keep both the number and the word together in one cell and have them save correctly, format the cell as Text before typing:

1. Select the cell (or cells) where both numbers and words will be entered.
2. On the ribbon, select Home > Number Format (drop‑down) > Text.
3. Now type the number and word (for example, 123 ABC) and press Enter.

If the entry is already in the cell and Excel has changed it, clear the cell, set the format to Text as above, then retype the value.

If Excel still tries to interpret a number in a special way (for example, 1e9 as scientific notation or something that looks like a date), type an apostrophe first, then the value, such as:

• '123 ABC
• '1e9

The apostrophe forces Excel to treat the entire entry as text and will not be printed or displayed in the cell.

If a small green triangle appears in the corner of the cell indicating “number stored as text,” it can be ignored, or select the triangle and choose Ignore Error.

---

References:

• Stop automatically changing numbers to dates
• Basic tasks using a screen reader with Excel