Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Question
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Question
=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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Question
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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate question | Excel Worksheet Functions | |||
CONCATENATE Question | Excel Discussion (Misc queries) | |||
Concatenate Question | Excel Worksheet Functions | |||
IF(ISTEXT Concatenate formula question | Excel Worksheet Functions | |||
Concatenate question | Excel Worksheet Functions |