Is there a way I can create a hotkey to format a field from text to datetime? I can use Ctrl+Shift+# (21-Oct-13) to format to Date and Ctrl+Shift+@ (4:19 PM) to format as time. I'd like to see the date and the time. I know I can go into Format Cells... but I'd like a quicker way of doing this.
Is there an easy way to do this or to create a macro to accomplish this?