excel copy drops leading zeros
617001Feb 10 2009 — edited Jun 19 2009I have records with a part number that is a text field, but contains digits. When I export to excel, the excel spreadsheet drops leading zeros from the part number.
How do I get the export to treat this as a text field and retain the zeros.
No, I have no option to make this a number field.