Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2013, 01:55 AM
nightkn8 nightkn8 is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2010 32bit
Novice
How to set month+1 and horizontal line
 
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default How to set month+1 and horizontal line

Hi.
I want to ask 2 things.
First is about the auto updating date field. I was wondering is there a way to insert a field that could do "month+1" state. For example we got March (I can get that by typing MMMM in date options) instead of "March" I would like to get "April". I have tried (MMMM+1) with result : "March+1". How can I fix it and make it work ?

Apart from that is there a way to insert horizontal SOLID (not dashed) line in center of a text from left to right margin just like:


---------- TEXT ----------
without using autoshapes or tables.

Chears
Reply With Quote
  #2  
Old 03-15-2013, 10:46 AM
konopca konopca is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2003
Novice
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default

Here's a sample of text using tab settings for horizontal lines.
Attached Files
File Type: docx Sample Horizontal Line.docx (17.9 KB, 9 views)
Reply With Quote
  #3  
Old 03-15-2013, 10:58 AM
nightkn8 nightkn8 is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2010 32bit
Novice
How to set month+1 and horizontal line
 
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default

hey thank you but how can I get it solid not dashed?
Reply With Quote
  #4  
Old 03-15-2013, 11:09 AM
konopca konopca is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2003
Novice
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default

Oops sorry. How about this. Use the solid line dot leader, then select the text and format it from the Font menu on the Advanced tab as Lowered. Then select the tab after the text and return it to normal. Hope this helps.
Attached Files
File Type: docx Sample Horizontal Line.docx (48.4 KB, 9 views)
Reply With Quote
  #5  
Old 03-16-2013, 02:48 AM
nightkn8 nightkn8 is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2010 32bit
Novice
How to set month+1 and horizontal line
 
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default

That would be great but this is another way which includes few steps to achieve line so that means I suppose that in Word there are no easy ways to insert that kind of lines. How about that month+1 ?
Reply With Quote
  #6  
Old 03-17-2013, 04:02 PM
macropod's Avatar
macropod macropod is offline How to set month+1 and horizontal line Windows 7 64bit How to set month+1 and horizontal line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
  #7  
Old 03-18-2013, 12:17 AM
eNGiNe eNGiNe is offline How to set month+1 and horizontal line Windows 7 32bit How to set month+1 and horizontal line Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

I've seen references to Border > Horizontal line, but never used it. Ther's also a fairly recent forum post about overlines.
Reply With Quote
  #8  
Old 03-18-2013, 03:52 AM
macropod's Avatar
macropod macropod is offline How to set month+1 and horizontal line Windows 7 64bit How to set month+1 and horizontal line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

For the horizontal line, you could use a single tab either side of the text, formattted with the strikethrough attribute. Simply use tabs either side of the text, with a centre-aligned tabstop for the text and a right-aligned tabstop after it to continue the line to the margin.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 03-19-2013, 12:09 AM
eNGiNe eNGiNe is offline How to set month+1 and horizontal line Windows 7 32bit How to set month+1 and horizontal line Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Ah, that's what OP meant – I misread the question :-}
Reply With Quote
  #10  
Old 03-25-2013, 01:14 AM
nightkn8 nightkn8 is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2010 32bit
Novice
How to set month+1 and horizontal line
 
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default

I'm getting january with this formula. Any change that I do in it causes january return.
ex
{QUOTE "{=MOD({DATE \@ M},12)+1}/1/00" \@ "MMMM"}
{QUOTE "{=MOD({DATE \@ M},12)+2}/1/00" \@ "MMMM"}
{QUOTE "{=MOD({DATE \@ M},12)+2}/2/00" \@ "MMMM"}
all above will give january
Reply With Quote
  #11  
Old 03-25-2013, 01:38 AM
macropod's Avatar
macropod macropod is offline How to set month+1 and horizontal line Windows 7 64bit How to set month+1 and horizontal line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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,

In post #6, you'll see that there are four versions of the formula, as its workings are dependent upon your regional settings. You're evidently using the wrong version.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 03-25-2013, 04:25 AM
nightkn8 nightkn8 is offline How to set month+1 and horizontal line Windows XP How to set month+1 and horizontal line Office 2010 32bit
Novice
How to set month+1 and horizontal line
 
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default

I tried:
the first: {QUOTE "{=MOD({DATE \@ M},12)+1}/00" \@ "MMMM"}
gives me line "{=MOD({DATE @ M},12)+1}/00" when I update it.
second: {QUOTE "{=MOD({DATE \@ M},12)+1}/1/00" \@ "MMMM"}
gives me "january" when I update it

Im form Poland btw.
Reply With Quote
  #13  
Old 03-25-2013, 02:06 PM
macropod's Avatar
macropod macropod is offline How to set month+1 and horizontal line Windows 7 64bit How to set month+1 and horizontal line Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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,

OK, being from Poland, you may need to use the 3rd or 4th version in post #6.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
month horizontal line



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set month+1 and horizontal line Shorten/delete auto-converted dotted horizontal line? pstein Word 3 09-12-2012 01:05 AM
How to set month+1 and horizontal line Horizontal sawtooth line JamesT Word 3 10-29-2011 05:39 PM
Harassing word horizontal line mike0000 Word 2 08-10-2011 12:31 AM
How to set month+1 and horizontal line Horizontal line at bottom and top each page BrutalLogiC Word 1 07-03-2011 02:22 AM
How to set month+1 and horizontal line Putting a horizontal line in a Word Document -- should be simple, right? biotechguy Word 4 05-10-2010 11:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft