To ignore all numbers stored as text, you need to open the Data tab and select the Text to Columns option. Then, select the Delimited option from the Convert Text to Columns wizard.

Want an easier way to share your spreadsheet or workbook with non-Apple users? We’ll show you how to convert Apple Numbers to Excel on Mac, iPhone, and iPad.