When using Convert Text to Number, common questions usually involve formula refresh, format checks, and collaboration sync; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if formulas do not update immediately after conversion?
- Confirm that the target cells have already been converted and that the green triangle warning is gone.
- Check whether the formula range still includes cells that remain stored as text.
- Recheck the formula cell and trigger recalculation again if needed.
How can I tell whether a cell is text or a numeric value?
- Check the default alignment of the value in the cell.
- If a green triangle warning appears, the value is usually being recognized as text.
- After conversion, confirm that the warning is gone and test whether the value works in calculations.
Can other collaborators see the result after I convert text to numbers in a shared worksheet?
- Complete the conversion in the shared worksheet.
- Keep the network connection active and wait for synchronization.
- Other collaborators can see the updated numeric values when the sheet refreshes or continues syncing.
Glossary
| Term | Definition |
|---|---|
| Number stored as text | A value that looks like a number but is stored as text, which may prevent normal calculations. |
| Green triangle warning | A warning marker in the upper-left corner of a cell that indicates a possible formatting or input issue. |
| Numeric value | A number data type that can be used directly in formulas, summaries, sorting, and filtering. |