I am using the Export to Excel mod which works great.

The only problem I have is when Excel automatically opens within MSIE and imports the comma separated data. When this happens, Excel edits all numbers that begin with 0 (like a zip code, for example) to drop the initial 0.

Is there any way to prevent Excel from doing this automatically?

Thanks,

John

Hi John,

When importing, you can choose the type of that field as 'General or Text' at last step. To do that the zero lead will be not supressed.

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog