In Excel how can i enter in a value like 0021 without the zeros .

[Howie]

In Excel how can i enter in a value like 0021 without the zeros disappearing
and leaving me with just 21?

[Chip Pearson]

Use a custom number format of 0000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Howie" <Howie@discussions.microsoft.com> wrote in message
news:3FA043AC-50F3-46AD-B61E-766C07813C00@microsoft.com...
> In Excel how can i enter in a value like 0021 without the
> zeros disappearing
> and leaving me with just 21?