Conversion of Numeric Value to format to 5 digit with leading zeros to text value
I have a field pulled for Sharepoint, that is configured as a numeric value. I am then attempting to take this value and make sure it is always formatted as a 5 digit number with preceding zeros. From that point, I need to then convert it to a text value to match the formatting from other tables and "link" up as the same field.
Num(title,'00000') as title, text(title) as storelocation,
This is the arguement I am trying, but does not seem to work. When using a variation of if arguments, it blanket added zeros without considering it should only be a max value of 5 digits, and filling the preceding values with zero.
Tried that solution, however it did not accomplish the intended goal. If you see, below I am essentially trying to convert or format the non-5 digit values into 5 digit values. Then convert that output into text to match the other storelocation field in other tables.
You'll have to explain what problem you're encountering, because the formula in question should pad any number shorter than 5 digits with enough leading 0s to make it five digits - which is your stated goal.