I am currently using a workflow to update from field EmployeeID to EmployeeNumber. Basically I am adding a letter in front of the employeeID to create employeeNumber.
Ex. employeeID "123456" become employeeNumber "A123456"
it working fine, but now I need to make sure they all have A+6 digits even if they have less than 4 digits in the Employee ID.
Ex. employeeID "1234" should become employeeNumber "A001234" and not employeeNumber "A1234"