change the format of today(ctrl-;)

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

 

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

 

[Rick Rothstein]

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

 

[news.microsoft.com]

thanks.