Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Date and Time Function
I have a column of dates formatted as m/d/yyyy and another column of
times formatted as hh:mm:ss. I would like to merge them into one column. When I concatenate to do this the format of the date changes to a serial number and I can't get it to be formatted in m/d/yyyy. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should have a function for last date and time file was saved | Excel Worksheet Functions | |||
Date and Time Function | Excel Discussion (Misc queries) | |||
USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F | Excel Discussion (Misc queries) | |||
Date/Time Function | Excel Worksheet Functions | |||
Date & Time function | Excel Worksheet Functions |