Subject edited by HansV to be less vague than “excel”
I have a 6-digit field used in a look-up. If I type in leading zeros, no value is found from the look-up. How can I accomodate users typing in just the number (as 6543) which works, and users typing in the number as a 6-digit number (as 006543) which doesn’t work.