Import leading zeros

Need to import a number like "000123" and keep the leading zeros intact? The import reference explains how to do it by inserting an apostrophe in front of the number in Excel. Example: "'000123" is imported as "000123" instead of "123"