Concatenate Question
=A1&B1&TEXT(C1,"000")&TEXT(D1,"00") if the cells contain integer values.
Otherwise, if you've rounded the values in A1 and B1 in the display
formatting, try
=TEXT(A1,"0")&TEXT(B1,"00")&TEXT(C1,"000")&TEXT(D1 ,"00")
--
David Biddulph
"CJN" wrote in message
...
OK, I am beginning to understand. More specifically, if I have adjacent
columns that have these values:
9 30 000 01
What would the formula be to create a value of 93000001 in a cell?
"David Biddulph" wrote:
=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,
|