'0' x (6-length($defectid)).$defectid
Cheers Chris
In reply to Re: Formating Numbers Preceding 0's by chrism01 in thread Formating Numbers Preceding 0's by ~~David~~