Microsoft Excel 2016 for Mac – Error Checking Numbers as Text

By default, Microsoft Excel has error checking that will place a warning indicator next to all cells that have numbers in a cell formatted to be text. It’s common to have serial numbers and other entries that will contain text and numbers in the same field, so having a warning about it is unnecessary.

To disable this and turn it off, in the Mac version, go to the Excel Menu and choose Preferences > Error Checking > and remove the check next to “Numbers formatted as text” as shown below.

20150801sa-microsoft-excel-error-checking-numbers-as-text

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s