hi,
If you are going to be printing the numbers with preceeding zeros then you
will have to format the numbers to text. otherwise the preceeding zeros will
not print.
you can set a custom number format to show the preceeding zeros ON the sheet
but mathmaticly speaking, preceeding zeros on a number are not necessary
which is why excel knocks them off. having the numbers formated as text (or
preceeded with an apostrophe ( ' )) is the only way you can show AND print
the preceeding zeros.
yeah i know....seems weird. but as i have told people in the past. when
dealing with a computer, human logic goes out the window. the only logic that
applies is computer logic.
regards
FSt1

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