Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in diff. cells
I have a excel sheet with the dates in 3 different cells, e.g. 21/05/2006,
appears like cell a1 21, cel b1 05 and cell c1 2006 tried merging the cells but did not work, need to have this date in one cell any help will be appreciated thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in diff. cells
=TEXT(A1&"/"&B1&"/"&C1,"dd/mm/yy") -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564061 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in diff. cells
thank you very much
"VBA Noob" wrote: =TEXT(A1&"/"&B1&"/"&C1,"dd/mm/yy") -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564061 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in diff. cells
=DATE(C1,B1,A1)
HTH -- AP "Gerald" a écrit dans le message de news: ... I have a excel sheet with the dates in 3 different cells, e.g. 21/05/2006, appears like cell a1 21, cel b1 05 and cell c1 2006 tried merging the cells but did not work, need to have this date in one cell any help will be appreciated thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Format Cells - Date options | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions |