This project has moved and is read-only. For the latest updates, please go here.

Inserting a DateTime value in a cell

Oct 18, 2013 at 8:13 PM
I need to insert values into cells that are date AND time. (For example "9/23/2013 10:15:22 AM") and have Excel recognize it as a datetime so that sorting works (for example "10/1/2013 09:12:07 AM" should sort AFTER "9/30/2013 11:55:12 PM" -- of course 1 sorts before 4 in a text cell, so I need the cell to be recognized as a date and time).

Any ideas?