=TEXT(NOW();"mm/yy hh:mm")
Is there a shortcut key/combo that will input the current date and time, and if so, how do I have the cell display it as mm/yy hh:mm ?
Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.
[quote
Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.
The cell that houses the date/time, go to Format/Cells/Number tab/select custom and use mm/yy hh:mm
[quote
Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.
But how to format the date part as mm/yy ?