Thread: CONVERT NOs TO EAN 8 BY ADDING LEADING ZEROS
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default CONVERT NOs TO EAN 8 BY ADDING LEADING ZEROS
Hello,

David's one would be my preferred one but here's just another example:
=RIGHT(REPT(" ",8)&A1,8)

Regards,
Bernd
Reply With QuoteReply With Quote