Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format the "date" button for a header | Excel Discussion (Misc queries) | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) |