Prev: Pivot table in Excel 2007
Next: Zeros displaying in cell when using = sign
From: cheppy on 3 Jun 2010 16:56
I have a Zip Code Table with only the first 5 digits and do not have the last
4 digit.
How can I make them in 9 digit zip code with the last 4 digit as 0000?.
manually I've been doing this (01234 then add the last digit as -0000)
which come to this 01234-0000.
From: Gary''s Student on 3 Jun 2010 17:58
With a five digit ZIP code in A1, in another cell:

=A1 & "-0000"

--
Gary''s Student - gsnu201003


"cheppy" wrote:

> I have a Zip Code Table with only the first 5 digits and do not have the last
> 4 digit.
> How can I make them in 9 digit zip code with the last 4 digit as 0000?.
> manually I've been doing this (01234 then add the last digit as -0000)
> which come to this 01234-0000.
 | 
Pages: 1
Prev: Pivot table in Excel 2007
Next: Zeros displaying in cell when using = sign