This content has been marked as final. Show 2 replies
When I am exporting my data to excel 2007 I am having issue with Customer ID field.
Its a nine digit field usally starting with '0' i.e. 079829909
Once I export it to excel its not preserving the leading zero i.e 79829909.
Usally to over come this I convert the field to Text so that it holds the leading zero.
Please advise the best option to avoid such scenarios while exporting data.