I'm attempting to create a Vendor List + Vendor Bank Account (Link Table). All working well, however the leading zeros from the bank account number are being dropped. eg. 001234 will come through as 1234 only.
And before you ask, I did try to format the affected cells as 'Text'. Still no joy? Help
Jason
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Jason -
As you have discovered, Excel does not like leading zeros on numbers.
Unfortunately, the method that we could use in Jet Essentials to work around that limitation is not applicable to Jet Express.
As a result, I know of no method to accomplish this.
Kind Regards,
HP -
Jet Reports Historic Posts Hi
I also encountered the same issue as well. I had to design a workaround by finding a spare field and update the vendor no. to it with an Apostrophe (Single quote mark) infront. Then I call the spare field instead of the vendor no.
Thank you,
Tan Eng Siong -
Jet Reports Historic Posts Another option (that doesn't require a mod or a spare field) is to format the cell with the NL>Table function as Text while in design mode. When the report is refreshed code fields with leading zeros will now be treated as text fields and the leading zeros will not drop. The downside is that cell has to be formatted as text in design mode each time before refreshing the report.
Don
Please sign in to leave a comment.