I would like to be able to combine cells with 4 digits and 2 digits
respectively into a cell that results in the entire number returned when zero
as the first or last digit of the donor cell. I want the zero to remain in
place. Such as 3064 in A4 and 01 in B4 becoming 306401. I have tried to
concatenate using absolute value $, and ". I have also tried formatiing with
set criteria such as 000000 or ###### and It does not work. I am using Excel
2003. What am I doing wrong?