Concatenate Question

C

CJN

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,
 
D

Dave Peterson

=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.
 
C

CJN

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?
 
D

David Biddulph

=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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to add two spaces into a number stored as text 4
Concatenate cells with line breaks in them 4
Cell reference in formula string displays abbreviated value 2
Concatenate function 2
Concatenate 5
concatenate 2
Macro to concatenate with previous bold cell 0
Have 4 email addresses Want to auto forward all in one of them 0

Top