Fix a problem · Excel
How to fix numbers stored as text in Excel
- Select the cells with the green triangle
- Click the warning sign next to them
- Choose Convert to Number
- For a whole column, choose Data > Text to Columns and click Finish
More in Excel
- How to format cells as currency, percent and dates in Excel
- How to use SUM, AVERAGE and COUNT in Excel
- How to use SUMIFS and COUNTIFS in Excel
- How to use the UNIQUE function in Excel
- How to fix dates showing as numbers in Excel