Thread: sorry i put wrongly for padded leading 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tango tango is offline
external usenet poster
  
Posts: 45
Default 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
Reply With QuoteReply With Quote