Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2009, 07:10 AM
Karthick Karthick is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2007
Novice
Date Formatting in MS word 2007
 
Join Date: Dec 2009
Posts: 7
Karthick is on a distinguished road
Question Date Formatting in MS word 2007

i would like to print the last month in words AUTOMATICALLY.
When i used to open the doc, it shows the previous month in words.
Since, current month is December, the doc shouls displays as "November"



I had tried out this by using the below code in word document but failed to meet the requirement:
{={date \@ "MM"}-1 \@ "MMMM"}

The above just displays the month in number as "11" insated of in words(November)

Could any body solve this problem?

If so, i will be so thankful for them.
Reply With Quote
  #2  
Old 12-20-2009, 11:07 PM
Karthick Karthick is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2007
Novice
Date Formatting in MS word 2007
 
Join Date: Dec 2009
Posts: 7
Karthick is on a distinguished road
Default

I feel very thankful if anybody helps me with a superb solution
Reply With Quote
  #3  
Old 12-24-2009, 01:43 AM
Karthick Karthick is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2007
Novice
Date Formatting in MS word 2007
 
Join Date: Dec 2009
Posts: 7
Karthick is on a distinguished road
Default

Could anybody help me at the earliest?..........
Pleaseee...I am helpless
Reply With Quote
  #4  
Old 01-07-2010, 01:58 AM
Karthick Karthick is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2007
Novice
Date Formatting in MS word 2007
 
Join Date: Dec 2009
Posts: 7
Karthick is on a distinguished road
Default

Could anybody help me ? Its very urgent.

I vl be very thankful for them if anybody resolves it.

PLeaseee....
Reply With Quote
  #5  
Old 01-19-2010, 05:54 AM
HoresXB HoresXB is offline Date Formatting in MS word 2007 Windows XP Date Formatting in MS word 2007 Office 2003
Novice
 
Join Date: Jan 2010
Posts: 2
HoresXB is on a distinguished road
Default Try this

You need 2 modifications:
1. use QUOTE to introduce something into another function
2. consider Jan=1, your formula generates zero, an invalid number for month


{QUOTE "1-{=MOD({DATE \@ "M"}+10,12)+1}-1" \@ "MMMM"}

note:
in the primary structure
{QUITE "d-m-y" \@ "MMMM"}
where "d-m-y" is a necessary parameter; you have to **create** a valid date. All you concern is the operation of month, therefore both day and year could be any number you like.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 formatting help please! rust1477 Word 0 11-11-2009 06:28 PM
Date Formatting in MS word 2007 Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Word Formatting Peter B. Word 5 05-10-2006 08:13 AM
Date Formatting in MS word 2007 Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.


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