To best simulate, input the following….
A2 = 021
B2 = 05
A3 = update product_code = ‘A2’ where id_code = ‘B2’
I have formated each cell as custom “000” for A2, “00” for B2. This is to ensure that by typing 5 in B2, I will get 05, which is the correct format I need.
If you enter in the formula seen in A3, the leading zeros drop, I need the leading zeros there. What am I do wrong?
