You can ignore data entry warning that Microsoft Excel 2007 or later displays. However, perform this procedure to turn off the warning message.
Based on the version, do one of the following:
In Microsoft Office Excel 2007, click Excel Options.
In Microsoft Office Excel 2010, click FileOptionsExcel Options.
ADDITIONAL INFORMATION:
For other Microsoft Office Excel versions, use the appropriate options.
In Microsoft Office Excel 2010, in the left navigation pane, click Formulas and clear the Numbers formatted as text or preceded by an apostrophe check box.
