change the format of today(ctrl-;)

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

when I insert today using shortcut(ctrl-;),
the format is yyyy-mm-dd by default.

I want the format of yyyy.mm.dd.
how can I change that?

I use korean version of excel 2007.

TIA.
 
I think that Excel uses the Windows Short date format.

You could try changing that short date format via the control panel.

But remember this setting is used by all of windows.
 
Back
Top