Help - Date Format
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 |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com