how to insert a date in the right date format

[Rob Veelenturf]

In the menu bar when I go to Insert > Date and time... I only find
American date and time formats.
I need to insert Dutch dates where the day comes before the month.
My OS X system prefs are all Dutch. So what's wrong here?

 

[Oz Springs]

Use this macro and put it in a button on your toolbar using the customize
command:

Sub insertdate()
'
' insertdate Macro
'
Selection.InsertDateTime DateTimeFormat:="dddd, d MMMM yyyy", _
InsertAsField:=False
End Sub

This will give you the format: Monday, 20 December 2004. If you don¹t want
the day of the week, just delete the ³dddd,²

HTH



Oz