Thread: Zip Code Last 4 Digit as Zero
View Single Post
  #2  
Old June 3rd, 2010, 10:58 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
external usenet poster
  
Posts: 7,584
Default Zip Code Last 4 Digit as Zero
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.