View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EMayor EMayor is offline
external usenet poster
 
Posts: 1
Default losing the leading zero when merging zip+4 postal code

In my worksheet I have one column with a 5-digit zip code and another column
with the zip+4 code in the format -1234. I use CONCATENATE to join them
together, which works expect in the case of a zip code with a leading zero,
as in 01002-1234. The result comes out as 1002-1234. How can I merge the
cells together without losing the leading zero?