Modifying cell entries when changing format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to alter a column of the format "1/12/2007 9:07:00 AM" to format
"1/12/2007" - that is, so that only the date shows up. When I do this, I also
would like to get the data to take on this actual form (rather than just
showing up this way in the cell, but remaining in the old format ("1/12/2007
9:07:00 AM").

I tried certain wildcards in Find/Replace, but have been unsuccessful. Thus
far, all I've been able to do is Find "1/12/2007*" and Replace with
"1/12/2007." However, that requires me to go date by date, and I have over
300 of them.

Is there a formula or wildcard format that would succeed in doing this?
Thanks in advance!
 
Anthony

Dates are integers, time is a decimal of one day. So use a helper column if
the date-time is in A1 use +INT(A1)

Or use a macro to change the data. Copy the code into a VB Module (ALT+F11,
Insert, Module,File, Quit) to return to the sheet.

select the dates, Press ALT + F8, select the macro and click Run.

Peter
 
Back
Top