View Single Post
  #1  
Old June 3rd, 2010, 09:56 PM posted to microsoft.public.excel.worksheet.functions
cheppy
external usenet poster
 
Posts: 1
Default Zip Code Last 4 Digit as Zero

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.