sorry i put wrongly for padded leading 0
 

dear all

this is to pad with trailing 0
=IF(D2<14, D2&REPT("0",14-LEN(D2)),D2)

why when i put in this way it doesn't seem to work?
=IF(D2<14, REPT("0",14-LEN(D2)&D2),D2)

thanks

sorry i put wrongly for padded leading 0
 

I suspect you IF condition is written improperly -- I think this is what you
want.
=IF(LEN(D2)<14,REPT("0",14-LEN(D2))&D2,D2)

--
Regards,
Tom Ogilvy

"tango" wrote in message
om...
dear all

this is to pad with trailing 0
=IF(D2<14, D2&REPT("0",14-LEN(D2)),D2)

why when i put in this way it doesn't seem to work?
=IF(D2<14, REPT("0",14-LEN(D2)&D2),D2)

thanks