Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Does it also happens if you export to csv? If not it's an excel-feature.
- Marcus
Yes it does weather I do CSV or Excel I loose 0's
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