Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, need some help on formatting a cell with concatenate function. Pls see
example below ; cell A1 = 9 Sep 2007 ( date formatted ) cell A2 = Margin (text) In cell A3, I need to combine cells A1 & A2 and get " Margin 9 Sep 2007". When I used concatenate formulae in cell A3, date doesn't come but a value 39334 appears eventhough cell A3 is date formatted. Pls advise how to get the date format on cell A3. Thanks -- Cheers ! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=A2 & " " & TEXT(A1,"d mmm yyyy")
-- Gary''s Student - gsnu200743 "Sena" wrote: Hi, need some help on formatting a cell with concatenate function. Pls see example below ; cell A1 = 9 Sep 2007 ( date formatted ) cell A2 = Margin (text) In cell A3, I need to combine cells A1 & A2 and get " Margin 9 Sep 2007". When I used concatenate formulae in cell A3, date doesn't come but a value 39334 appears eventhough cell A3 is date formatted. Pls advise how to get the date format on cell A3. Thanks -- Cheers ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with CONCATENATE! | Excel Discussion (Misc queries) | |||
Concatenate | Excel Worksheet Functions | |||
concatenate | Excel Worksheet Functions | |||
IF, IF, Concatenate? | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |