Input of date and time into Excel
Posted on 2011-03-09
We have an excel spreadsheet with a few fields that require the user to enter a date and time. Example: 3/9/2011 1:14 PM. We have the cells formatted as date and time but I was wondering if there is an easy way to help with the entry. Like and input Mask in Access.
Example: User enters 3092011 114pm and the cell shows 3/9/2011 1:14 PM
I just want to save them some key strokes.