Please Help.
I want to build a script to autofill a cell if the value entered is short. i.e all cells should be in the format A9999999. This is fine if the number is B1234567 however if the number is B0000123 then often our people may only enter B123 as it may be all that someone wrote on the item. I do not wish to put a validation on the cells which forces the person to enter the predefined format or number of characters. I would prefer they just entered what they saw. I would like a script that acted on a change to any value in column A from Row 9 down and put the zero's in after the alpha if applicable.
Any idea's would be appreciated.
I want to build a script to autofill a cell if the value entered is short. i.e all cells should be in the format A9999999. This is fine if the number is B1234567 however if the number is B0000123 then often our people may only enter B123 as it may be all that someone wrote on the item. I do not wish to put a validation on the cells which forces the person to enter the predefined format or number of characters. I would prefer they just entered what they saw. I would like a script that acted on a change to any value in column A from Row 9 down and put the zero's in after the alpha if applicable.
Any idea's would be appreciated.