How to get the leading zero's added in a document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sam - 17 Oct 2006 21:40 GMT

hi
i have a document which is added with leading Zero's in some of the
columns

for eg., in the ZIPCODE column my value is 09281 but in the display i am
getting it

as 9281. But i want it with the original value. Can anyone tell me how to
get the

original values

Reply to this Message

Beege - 17 Oct 2006 21:48 GMT

> hi
> i have a document which is added with leading Zero's in some of the
[quoted text clipped - 7 lines]
>
> original values

Sam,

Most people don't use zip codes in calculations, so in Excel they might as
well be text that just look like numbers.

So...

Format/Cells/Text

or

Format/Cells/Custom/00000

HTHelps

Beege

Reply to this Message

Jim Thomlinson - 17 Oct 2006 21:49 GMT

Signature

HTH...

Jim Thomlinson

> hi
> i have a document which is added with leading Zero's in some of the
[quoted text clipped - 7 lines]
>
> original values

Reply to this Message

Jim Thomlinson - 17 Oct 2006 23:21 GMT

Well that did not post right... Try this for a custom format.

[>99999] 0000-00000;00000

it will pad zeros and it will format bot 5 and 9 digit zips correctly...

Signature

HTH...

Jim Thomlinson

> c
>
[quoted text clipped - 9 lines]
> >
> > original values

Reply to this Message