Preformat using a custom format like 000 then put 1 in the first cell and
right click lower right corner and drag down the formula and select fill
series when you release the mouse or simply format as text and put 001 in a
cell then copy it down


--


Regards,


Peo Sjoblom



"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.