Hi

I'm guessing that the cells contain only 0 but are formatted to display 00.
Try something like this:
=TEXT(C6,"00")&TEXT(C7,"00")&TEXT(C8,"00")

Andy.

"kier" wrote in message
...
I am trying to combine values from many cells into one, but the values have
zero places that get lost after combining them. For example, I need to
combine "00"&"00"&"01" so that the new value reads 000001. But when I do
this
with the concatenate function, I lose the 1st zero in every cell so that
it
reads 001.
Can anyone help?
Thanks!
-Kier