Forum Discussion
Convert text in a cell to number
A colleague of mine opened an Excel spreadsheet exported from SAP. One column contains numbers only, but is recognized as text. She does not see the regular green triangle in front, neither the yel...
Hi kaibisnes,
These steps might be helpful.
File > Options > Formula - Error Checking Rules
Make sure the option is checked "Numbers formatted as text or preceded by an apostrophe"
Regards, Faraz Shaikh, MCT, MIE, MOS Master, Excel Expert