Help - Date Format

E

Edmundo

I want to link the contents of two cells together using &. One is tex
the other in a date format but when I do it I get the text and the dat
no. not the format it is in in the original cell...help; how do I d
it?

(also what is the custom format setting to turn say 1:30 to 01:30?)

Any help most appreciated
 
T

Top Bombing

You need to type =A1&TEXT(B1,"dd/mm/yy") ~ or "mm-dd-yyyy", etc depending how
you want the date displayed

As for the Custom Format it's hh:mm
 
E

Edmundo

Done it;

=A1&", "&TEXT(A2, "d-mmm-yy")

still stuck on turning 24 hour clock times 00 to 09: from eg 1:30 t
01:30 without eg 023:3
 
M

Max

.. still stuck on turning 24 hour clock times 00 to 09:
from eg 1:30 to 01:30 without eg 023:30
Click to expand...

Try a custom format of: hh:mm

Or, used in the similar manner in TEXT():
=A1&", "&TEXT(A2, "hh:mm")
 
M

Max

You're welcome ! Thanks for the feedback ..
... you probably missed the 2nd part of Top Bombing's earlier response <g>
 
Top