I'm trying to build an email address from static text + text on the raw input @(x,x,x,x,x) and filling that input with zeros so that the length is always 5 characters long.
I saw someone mention a =left('00000', @location, 5) but that doesn't display right.