In excel, we can insert date using "CTRL ;" shortcut, but the date inserted are in "M/d/yyyy" format. I want to insert date in the "d-MMM-yy" format them I've re-config the Region and language as below, but it doesn't help. Anyone know how to insert date using hotkey with custom format ? Please share! Many thanks!
Thanks Bob for quick answer, but it's not what I looking for, cause I often use Ctrl+; in the excel comment then I need another tip for insert the date.