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

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

Any help most appreciated.


--
Edmundo
------------------------------------------------------------------------
Edmundo's Profile: http://www.excelforum.com/member.php...o&userid=24837
View this thread: http://www.excelforum.com/showthread...hreadid=383873

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

"Edmundo" wrote:


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

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

Any help most appreciated.


--
Edmundo
------------------------------------------------------------------------
Edmundo's Profile: http://www.excelforum.com/member.php...o&userid=24837
View this thread: http://www.excelforum.com/showthread...hreadid=383873

Done it;

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

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


--
Edmundo
------------------------------------------------------------------------
Edmundo's Profile: http://www.excelforum.com/member.php...o&userid=24837
View this thread: http://www.excelforum.com/showthread...hreadid=383873

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

Try a custom format of: hh:mm

Or, used in the similar manner in TEXT():
=A1&", "&TEXT(A2, "hh:mm")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Superb...thank you


--
Edmundo
------------------------------------------------------------------------
Edmundo's Profile: http://www.excelforum.com/member.php...o&userid=24837
View this thread: http://www.excelforum.com/showthread...hreadid=383873

You're welcome ! Thanks for the feedback ..
... you probably missed the 2nd part of Top Bombing's earlier response <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Edmundo" wrote

Superb...thank you