"FSt1" wrote in message
...
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.

Yes they will in exactly the same way as the currency symbol prints even
although it is not really there.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"FSt1" wrote in message
...
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.