Zero Placeholders in number cell

Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For
example I have a column with number cells which calculate sequentially. I
have a need for the first and subsequent numbers to have four digits (ex.
0001, 0002 etc.). The zero's of course do not show when they are entered.
Is there a way to do this and still have it calculate??? Thanks in advance.
--
B. Parizo

It's called leading zeroes. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"B. Parizo" <BParizo@discussions.microsoft.com> wrote in message
news:E110B9F3-1745-4DDE-9128-C83184FE7D5F@microsoft.com...
> Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell.
> For
> example I have a column with number cells which calculate sequentially. I
> have a need for the first and subsequent numbers to have four digits (ex.
> 0001, 0002 etc.). The zero's of course do not show when they are entered.
> Is there a way to do this and still have it calculate??? Thanks in
> advance.
> --
> B. Parizo

Try this:

Format>Cells>Custom in the type box: 0000


"B. Parizo" wrote:

> Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For
> example I have a column with number cells which calculate sequentially. I
> have a need for the first and subsequent numbers to have four digits (ex.
> 0001, 0002 etc.). The zero's of course do not show when they are entered.
> Is there a way to do this and still have it calculate??? Thanks in advance.
> --
> B. Parizo

That was the answer. Thank you!
--
B. Parizo


"David Hepner" wrote:

> Try this:
>
> Format>Cells>Custom in the type box: 0000
>
>
> "B. Parizo" wrote:
>
> > Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For
> > example I have a column with number cells which calculate sequentially. I
> > have a need for the first and subsequent numbers to have four digits (ex.
> > 0001, 0002 etc.). The zero's of course do not show when they are entered.
> > Is there a way to do this and still have it calculate??? Thanks in advance.
> > --
> > B. Parizo