Even simpler than that:
RIGHT("000000" & {Merch Inventory...}, 6)
Even simpler than that:
RIGHT("000000" & {Merch Inventory...}, 6)
Fantastic! That works perfectly. Thank you. Can you explain a little more about what the RIGHT command is? I thought it would be a LEN command. But I am really a novice.
Fantastic! That works perfectly. Thank you. Can you explain a little more about what the RIGHT command is? I thought it would be a LEN command. But I am really a novice.
RIGHT() says “return the last t#] characters at the end of a string”. There is also the “cousin” function LEFT() which does the same thing except its “return the first t#] characters”.
LEN() returns “how many characters are in a string”. It also only works on strings so you would have to force your numbers to be strings by doing #&""
. So a LEN solution would be something like
IF(
LEN({Merch Inventory...}&"") = 1,
"00000" & {Merch Inventory...},
IF(
LEN({Merch Inventory...}&"") = 2,
"0000" & {Merch Inventory...},
IF(
LEN({Merch Inventory...}&"") = 3,
"000" & {Merch Inventory...},
IF(
LEN({Merch Inventory...}&"") = 4,
"00" & {Merch Inventory...},
IF(
LEN({Merch Inventory...}&"") = 5,
"0" & {Merch Inventory...},
IF(
LEN({Merch Inventory...}&"") = 6,
{Merch Inventory...}
))))))