Concatenate Question
=TEXT(A1,"000")&TEXT(A2,"000")
--
David Biddulph
"CJN" wrote in message
...
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,
|