How to display zeros at the beginning of a number?

's Computer Specifications

I have inventory numbers that start with zeros. How do I format cells
to display these zeros. ex../. 000456789
FYI The numbers do not have the same amount of zeros in front of them.
Thanks

's Computer Specifications

hi,

use the custom format 000000000

--
isabelle

Le 2011-04-21 07:08, Larry Allen a écrit :
> I have inventory numbers that start with zeros. How do I format cells
> to display these zeros. ex../. 000456789
> FYI The numbers do not have the same amount of zeros in front of them.
> Thanks

's Computer Specifications

Format as Isabelle suggests or preface with an apostrophe which won't show in
the cell.

You can pre-format the cells as Text but if you change the format you will lose
the zeros.

Gord Dibben MS Excel MVP

On Thu, 21 Apr 2011 04:08:51 -0700 (PDT), Larry Allen <(E-Mail Removed)>
wrote:

>I have inventory numbers that start with zeros. How do I format cells
>to display these zeros. ex../. 000456789
>FYI The numbers do not have the same amount of zeros in front of them.
>Thanks

's Computer Specifications

hi Gord,

no, not a text format, it is a digital format, no apostrophe!
it appears in the cell or at to print as 001234567 or 000123456
but in the formula bar is 1234567 and 123456

--
isabelle

Le 2011-04-21 10:13, Gord Dibben a écrit :
> Format as Isabelle suggests or preface with an apostrophe which won't show in
> the cell.
>
> You can pre-format the cells as Text but if you change the format you will lose
> the zeros.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 21 Apr 2011 04:08:51 -0700 (PDT), Larry Allen<(E-Mail Removed)>
> wrote:
>
>> I have inventory numbers that start with zeros. How do I format cells
>> to display these zeros. ex../. 000456789
>> FYI The numbers do not have the same amount of zeros in front of them.
>> Thanks

's Computer Specifications

Why are you telling me?

Gord

On Thu, 21 Apr 2011 18:14:23 -0400, isabelle <(E-Mail Removed)> wrote:

>hi Gord,
>
>no, not a text format, it is a digital format, no apostrophe!
>it appears in the cell or at to print as 001234567 or 000123456
>but in the formula bar is 1234567 and 123456

's Computer Specifications

i'm sorry Gord, referral mistake

--
isabelle

Le 2011-04-21 20:13, Gord Dibben a écrit :
> Why are you telling me?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Losing zeros at the beginning of a number	RichardSchollar	Microsoft Excel Misc	0	21st Dec 2006 02:16 PM
RE: Losing zeros at the beginning of a number	=?Utf-8?B?VmlrYXMgS3VtYXI=?=	Microsoft Excel Misc	1	21st Dec 2006 01:00 PM
RE: Losing zeros at the beginning of a number	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Misc	0	21st Dec 2006 12:43 PM
Re: How can I keep zeros in the beginning of a number in excel	Doctorjones_md	Microsoft Excel Misc	0	8th Dec 2006 05:07 PM
How do I get the zeros to show up in the beginning of a number?	=?Utf-8?B?Y21yZWlzbmVy?=	Microsoft Excel Misc	6	15th Sep 2005 12:59 PM