Hi there @chimdee,
if I got you right and your problem starts with loosing first zeroes when reading Excel file check this topic.
After you sort that out you can use Column Expressions as suggested by @izaychik63 in addition to String Manipulation and/or Rule Engine node…
Check here to see how to add new nodes to KNIME.
Br,
Ivan