change the format of today(ctrl-;)

  • Thread starter news.microsoft.com
  • 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.
 
D

Dave Peterson

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.
 
R

Rick Rothstein

Why don't you just Custom Format the cell to make it look like you want?
 
Top