Excel export: number stored as text

Number stored as Text in Excel

In some cases you need to export numbers as a text to excel. For example, you may have some alphanumeric codes in your DB, like 10001A, 10001B, ... 100011.

This results in Excel showing a warning "Number stored as Text" when editing these files:

This is an Excel way of protecting users from possible errors. You can safely click "Ignore Error" if you know that these fields should remain as text ones.

Disabling this check in Excel

In some cases this warning can be very annoying. It can be disabled permanently here: File --> Options --> Formulas --> Error checking rules --> uncheck the 'Number formatted as text or preceded by an apostrophe' option --> OK, like this:

You can restore this check any time you like, by following the same procedure.