When using Number Format, the most common questions are about formats not taking effect, dates showing as numbers, and whether formatting changes stored values; this FAQ includes 3 common answers and a glossary.
FAQ
Why did the cell not change after I modified the number format?
- Check whether the cell content is stored as plain text.
- If the value starts with an apostrophe or was entered as text, adjust the content first.
- Select the target cell again and reapply the number format.
Why is my date displayed as a number?
- A date shown as a number usually means the cell is currently using a General or Number format.
- Open the Number Format options again.
- Select the Date category and apply it to restore a standard date display.
Does number formatting change the actual value stored in a cell?
- Number formatting mainly changes how the value is displayed.
- It does not directly change the actual value stored in the cell.
- To change the underlying data, edit the original cell content.
Glossary
| Term | Definition |
|---|---|
| Number Format | The display rule applied to cell content, such as Number, Currency, Percentage, or Date. |
| Custom Format | A format type that uses a specific display rule for how cell content appears. |
| Text Format | A cell state in which content is treated as text, so some numeric formats may not display as expected. |