![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
I feel very thankful if anybody helps me with a superb solution
|
#3
|
|||
|
|||
![]()
Could anybody help me at the earliest?..........
Pleaseee...I am helpless |
#4
|
|||
|
|||
![]()
Could anybody help me ? Its very urgent.
I vl be very thankful for them if anybody resolves it. PLeaseee.... |
#5
|
|||
|
|||
![]()
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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2003 formatting help please! | rust1477 | Word | 0 | 11-11-2009 06:28 PM |
![]() |
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 |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |