Our customer ID field is alphanumeric and permits leading zeros. When we export reports to CSV and then open them in Excel the leading zero is removed. Is there any way to get Salesforce to prefix this field with an apostrophe or other mark that would designate the data as text and prevent Excel from automatically removing the leading zeros?
Edit: Salesforce addresses the issue with a workaround that I would rather avoid, if possible.
Edit 2: This field is encrypted and cannot be used in formulas.