This FAQ covers common questions about Number Conversion, including feature locations, conversion behavior, and key terms for spreadsheet cleanup tasks.
FAQ
Why are some conversion commands under Home while others are under Membership?
- Basic conversion tools are usually available from the Convert menu on the Home tab.
- Advanced tools are placed in Smart Toolbox under the Membership area.
- If you cannot find a feature, confirm whether you are signed in with an account that has the required membership.
Why does a text-formatted number sometimes look almost the same after I convert it to a number?
- This conversion mainly changes the stored data type, not always the visible text.
- Try using the result in a calculation, sort, or formula to confirm that it is now recognized as a number.
- If the result still seems incorrect, check whether the original content includes spaces, symbols, or other non-numeric characters.
Can I restore the original formula after using Keep Values Only?
- This action fixes the current formula result as a plain value.
- If you did not keep a backup copy, the original formula usually cannot be restored directly.
- It is recommended to duplicate the worksheet or save a separate file before applying the conversion.
What kind of text is most suitable for Text to Hyperlink?
- Complete URLs or clear link addresses are the most suitable input.
- If the text is only descriptive content, add the actual link address first.
- After conversion, click the cell to test whether the link opens correctly.
Glossary
| Term | Definition |
|---|---|
| Text-formatted number | Content that looks like a number but is stored as text in a cell, which can affect calculation and sorting. |
| Keep Values Only | A conversion that keeps the current displayed result and removes the original formula structure. |
| Text to Formula | A conversion that turns formula-like text into a working formula. |
| Formula to Text | A conversion that shows a formula expression as plain text for review or copying. |
| Hyperlink | Clickable content that opens a webpage, file location, or another target address. |