View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default incrementing numbers with preceeding zeros

Format as 000.
--
David Biddulph

"cristo" wrote in message
...
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.