Autocompletion of 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
 
G

Greg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top