Autocompletion of date

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

Hi,

Whenever I start to type in a date in the English format
(ie dd mmm yyyy), or if I just type 2004, I get a pop-up
autocompletion suggestion, but always in the American
style, ie yyyy-mm-dd. Is there any way to change the pop-
up to what I actually want, ie dd mmm yyyy?

Regards

Ali Smith
 
Ali,

I don't think so. That Autocomplete date feature is
fickle anyway. You likely to experience inconsistant
behavior at times.

I use a macro asigned to a keyboard short cut to enter a
date stamp in my documents:

Sub DateStamp()
' Inserts current date
Selection.InsertDateTime DateTimeFormat:="dd MMM yyyy",
InsertAsField:=False
End Sub


Note your format picture should be MMM vice mmm.
 
Back
Top