Hi all! Happy New Year :) Hoping for some help with formatting numbers…
For context: Employee ID #s at my company are all 8 digits, so if someone's ID # is 123456, we add leading 0s to the front so it would be "00123456" making all Employee ID #s 8-digits.
QUESTION: Is there a format-feature or formula I can use to adjust an entire column of our Employee ID #s? I need them to match exactly between sheets/columns so I can use VLOOKUP formulas, etc.
Any insight is appreciated. Thank you!