Assuming Data is in Col A (starting at Row 1), then put this formula into Col B.
NB.This will only resolve data that is 4 & 5 characters long. Everything else is assumed to be 6 characters
=IF(LEN(A1)=4,"00"&A1,IF(LEN(A1)=5,"0"&A1,A1))
Tiglet [reading]
Living on Earth is expensive, but it...