I have a data sheet that I have successfully exported to Excel including the leading zeroes in front of some of the code fields (ex. 000010). This was done using NumberFormat := ‘@’.
But when I’m trying to import this spreadsheet back into Navision, then the leading zeroes are not imported and the content of the “Cell Value as Text” is only 10.
I think that I have seen a solution to this problem, but now I simply cannot find it again.
Can you help?