No need for a formula, just format as text will do


--


Regards,


Peo Sjoblom



"JW" wrote in message
ups.com...
As David said, you can format the cell as 000. However, that will not
change the value in the cell. It will only pad the zeros via
formatting to make it appear as though they are truly in the cell. A
Text formula such as below will actually place the zeros in front of
your data. Of course, the formula would be what's really in the cell
unless you do a Copy--Paste Special--Values.
=TEXT(A2,"000")

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.