Leading 0 Export

[azmeerrehan]

I have a  table with a Customer_ID field  has leading zeroes in it for example (00123546). When I am exporting the  table  with any filters selected on the sheet , i get the correct Customer_ID with o's but if I export it without any  filters I loose the leading zeroes. I dont know if its a bug or am I missing something here.

I have already tried Num(Field,'0000000') and Text(Field)

Any Help is appreciated

[marcus_sommer]

Does it also happens if you export to csv? If not it's an excel-feature.

- Marcus

[azmeerrehan]

Yes it does weather I do CSV or Excel I loose 0's

[marcus_sommer]

For me it worked. Important by it is to open the csv within an editor and not in excel (which always has some "useful" own-intelligence):

- Marcus