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
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
=TEXT(A1&"/"&B1&"/"&C1,"dd/mm/yy")
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
>
>
=DATE(C1,B1,A1)
HTH
--
AP
"Gerald" <[email protected]> a écrit dans le message de news:
[email protected]...
>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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks