| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
losing the leading zero when merging zip+4 postal code
=CONCATENATE(TEXT(A1,"00000"),B1) -- Allllen "EMayor" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to prevent Remove Split or Unfreeze Panes? | Excel Discussion (Misc queries) | |||
| 2 Questions | New Users to Excel | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| How do I retain leading zero zip code formatting when saving as a. | Excel Discussion (Misc queries) | |||
| how do you display a zip code with a leading zero | Excel Discussion (Misc queries) | |||
Linear Mode
