Thread: HOW TO ZERO FILL A CELL THAT CONTAINS OTHER DATA EX. 000123?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ggugvrunt ggugvrunt is offline
external usenet poster
  
Posts: 1
Default HOW TO ZERO FILL A CELL THAT CONTAINS OTHER DATA EX. 000123?
You need to use a formula such as =RIGHT("000000000"&A1,9) to produce a 9
digit string with preceding zeros.
Reply With QuoteReply With Quote