View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cristo cristo is offline
external usenet poster
 
Posts: 2
Default incrementing numbers with preceeding zeros

How do I get incrementing numbers with prececing zero's. e.g. 001, 002, etc.
e.g for printing ticket numbers. I can't find a cell format that suits. Is
there a format or formula. I can't do it in page no's in word either.