On Sep 24, 5:09 pm, "Peo Sjoblom" wrote:
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.

Yes, formatting as text will work. But I have seen far too many cases
where the cell "magically" reformatted itself back into a number.