Excel by default align text format to a left corner of a cell and you may see the cell with a green triangle. This may result is formatting problems and formulas having text format with unexpected results. To learn, how to convert text to numbers, follow these steps:
1. Select a text format column, you may select specific range but make sure it is in the same column.
(To know how to select cells or ranges, click here)
2. Press Ctrl + 1 and select number, currency or accounting format.
1. Insert a new column next to text formatted column.
2. In a cell of new column type =VALUE(), inside the parentheses, type a cell reference with the text format. For example, select A1 in our example.