Frequently Asked Questions

« Previous
How do I exclude folders in the anti-virus scan?
Next »
EndNote error says "Error reading records.", when I do an online search in PubMed.

windows ubuntu macos xibo network zenworks android storage

73. How do I convert from text to numbers in Excel?

Excel uses local regional settings to try to decide what is a number or not.
  1. In this example even when converting to number Excel still believes that the numbers using decimal comma are text (or vice versa).

  2. However in system settings change to decimal comma (or vice versa).

  3. Restart Excel.
  4. Now mark the region and format cells again (using cmd-1) to category Number.
  5. Excel will show up small green triangles in the cells and when marking the region a small warning icon will show up.
  6. Use the drop down meny in the warning sign to Convert to number.
  7. Now things should look ok again with all numbers as numbers and not text.


This entry was last modified 2018-12-13


This documentation is covered by GNU Free Documentation License. 12 ms