Hi Ron,
I will try it on Monday and let you know. I really appreciate your help.

Thanks,
Lia
"Ron Coderre" wrote:

Try something like this:

A4: 3064
B4: either 01 (as text) or 1 (formated as 00)

C4: =A4*100+B4

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MSOChick" wrote:

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?