When I export a file into Excel, the leading zeroes disappear. How do you force Excel to treat the codes as text, and leave the zeroes? I need something that would act the way the Excel text import wizard does. I've tried enclosing the variable with single or double quotes, which sorta work, except that the quotes show up in Excel along with the zeroes.
I have used a couple of custom tags, but they are not preserving the leading zeroes so the text is importing into Excel with no leading zeroes.
For example (From CF: 0000 Import into Excel: 0)