=text(a1,"000")&" some text "&text(b1,"000")&" more text "&text(c1,"mm/dd/yyyy")

Same kind of thing with dates and money and number formats.

CJN wrote:

I am trying to concatenate some cells that have 000 in them. When I get the
result the 000 becomes 0. I need to retain the t digits in the result. How
may I do this?

Many Thanks,

--

Dave Peterson