Question Locked

How to Format Excel 2007 Date and Time value in Huge Database?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I currently have huge Excel 2007 data bases (> 100K rows) that have three columns Date Created, Date Modified, Date Last Uploaded. Each of the cell values under each Column displays a value such as 7/1/2001 12:00:00 AM. I need to be able to easily remove the time value from each cell and format the cell to a date format that I can easily sort. Any ideas on how to do this? I greatly appreciate your help.

3 replies

by jhicks22309

If those cells are displaying "values" then you already have a date format (m/d/yyyy h:mm) that can be sorted. You can highlite the three columns and change the format to a different date format if you prefer a short format. If the cells actually contain "text" then your sort won't give you what you're looking for. In that case you'll need to convert the text to a value with something like =DATEVALUE(A1) and then format that as your prefered date format.

by ballinger.le

jhicks, the cell contained text and your reco worked perfect. Thanks for your help.

This discussion is closed to new replies.