I have original cells formatted as m/d/yyyy h:mm because that is the way the
program I'm working with returns them. Example is 9/30/2006 15:00. I need
to get just a mm/dd/yyyy format. At this point I formatted the origninal
data as mm/dd/yyyy, but the problem is that the time still shows up in the
function bar but not in the cell. I need just mm/dd/yyyy and not the time to
show up. Is there a particular function that can help to reach just the
mm/dd/yyyy and not show times?

If date/time in column A

in B1 =INT(A1)

and copy down.

"Daren" wrote:

I have original cells formatted as m/d/yyyy h:mm because that is the way the
program I'm working with returns them. Example is 9/30/2006 15:00. I need
to get just a mm/dd/yyyy format. At this point I formatted the origninal
data as mm/dd/yyyy, but the problem is that the time still shows up in the
function bar but not in the cell. I need just mm/dd/yyyy and not the time to
show up. Is there a particular function that can help to reach just the
mm/dd/yyyy and not show times?

It worked and I just copied the values over and formatted the new cell as
mm/dd/yyyy. Thanks a lot!
"Toppers" wrote:

If date/time in column A

in B1 =INT(A1)

and copy down.

"Daren" wrote:

I have original cells formatted as m/d/yyyy h:mm because that is the way the
program I'm working with returns them. Example is 9/30/2006 15:00. I need
to get just a mm/dd/yyyy format. At this point I formatted the origninal
data as mm/dd/yyyy, but the problem is that the time still shows up in the
function bar but not in the cell. I need just mm/dd/yyyy and not the time to
show up. Is there a particular function that can help to reach just the
mm/dd/yyyy and not show times?