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.

Format as 000.
--
David Biddulph

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

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.

hi cristo.
try vith a personalized format 000
eliano

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

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.

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.

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

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.

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.