Hi,
The export function in my software provider suddenly changed the format in which numbers were reported. For example, the color code is 11, it used to show are 011, now it's just 11, 4 used to be 004, now it's just 4. My hundreds of v-lookups now no longer work!
Is there a function that can add zeros without using a super long if statement?
thank you!
The export function in my software provider suddenly changed the format in which numbers were reported. For example, the color code is 11, it used to show are 011, now it's just 11, 4 used to be 004, now it's just 4. My hundreds of v-lookups now no longer work!
Is there a function that can add zeros without using a super long if statement?
thank you!