incrementing numbers with preceeding zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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
 
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
 
FSt1 said:
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.
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
No need for a formula, just format as text will do

--

Regards,

Peo Sjoblom
Click to expand...

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