Hi, I have tried to get the date and time stamp from another tab but it does not space out in between.
How should I do it? My cell reads 5/8/2012 9:20:29 PM showing 5/9/2012 21:20.

My other tab in cell is =IF(ISBLANK('Raw '!S2),"",MONTH('Raw '!S2)&"/"&DAY('Raw '!S2)&"/"&YEAR('Raw '!S2)&"/"&HOUR('Raw '!S2)&":"&MINUTE('Raw '!S2)) and returns 5/9/2012/2:57.
Please help, I want only the date(m/dd/yyy) and time (hr:min) only. Prefered return value to be 5/9/2012 21:20. Thanks!