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
|