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

hi cristo.
try vith a personalized format 000
eliano

"cristo" wrote:

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.