Thread: [Solved] How to set month+1 and horizontal line
View Single Post
 
Old 03-17-2013, 04:02 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi nightkn8,

For the auto-date, you need a field coded like:
{QUOTE "{=MOD({DATE \@ M},12)+1}/00" \@ "MMMM"}
or:
{QUOTE "{=MOD({DATE \@ M},12)+1}/1/00" \@ "MMMM"}
or:
{QUOTE "{=MOD({DATE \@ M};12)+1}/00" \@ "MMMM"}
or:
{QUOTE "{=MOD({DATE \@ M};12)+1}/1/00" \@ "MMMM"}
depending on your regional settings. The 1st & 3rd are for regions using a D/M/Y format, whilst the 2nd & 4th are for regions using a M/D/Y format. The 1st & 2nd are for regions using commas for the thousands separator, whilst the 3rd & 4th are for regions using commas for the decimal separator.

Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote