This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi just a suggestion try using this REPT(“0”, 4 - LEN("" & RecID))) & RecID where Recid is the numeric field you wish to format and the number 4 is the number of leading zeros you wish to have.