Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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! enter image description here


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.

share|improve this question
add comment

1 Answer

The date format in Excel depends on how the cell is formatted:

Screenshot of format cells box
Click for full size

  1. Select the correct format for the cell(s).
  2. Enter the date with Ctrl+;.
  3. It will appear with the default format. Leave the cell (arrow key, enter, tab, click out, etc) and the format will update automatically.

You can also adjust the formatting after inserting the date.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.