Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.