CONCATENATE

[Digitborn.com]

Hello,

In Excel 2003 Cell when I write a formula with CONCATENATE function i meet a problem. The problem is when I try to CONCATENATE cells which includes formats as Date and Time. It automatically format the cell in General format and then CONCATENATEs it. So, I can see some digits except dates and times values. Can you advice on this?

 

[Lewiy]

To combine A1 (containing a date) and B1 (containing text), use the TEXT function to specify the output format of the cell value. You can use any valid number format between the quotes:

=CONCATENATE(TEXT(A1,"dd/mm/yyyy"),B1)

 

[Peter_SSs]

Not quite sure what your original cells have in them or which cells they are, but maybe something along these lines?
=CONCATENATE(TEXT(A1,"d/mm/yy h:mm")," , ",TEXT(B1,"d/mm/yy h:mm"))
or this?
=CONCATENATE(TEXT(A1,"d/mm/yy")," ",TEXT(B1,"h:mm"))

 

[Digitborn.com]

I knew it was too easy Thanx ppl