I suspect it uses the short date format. This can be redefined for windows
in the regional settings in the control panel.

--
Regards,
Tom Ogilvy

"Michael Singmin" wrote in message
...
Hello group,

Ctrl ; inserts the current date into a cell
It is always formatted as the first choice
for dates viz. *14-03-01

Can I change the default format to 14-Mar-01 whenever
I use Ctrl ;

Thanks,

Michael Singmin