Thanks to antville.org
Wednesday, 21. April 2004
Date format

I am fed up with the two standards of writing a date. When will we people in the world start thinking the world as a global village? For last several years I am using Mail Merge function to create TDS certificates. This year when I used the latest version of office, I noticed that when I merge a date field from excel to word, it automatically changes from dd/mm/yy to mm/dd/yy format. I have already changed the country setting to UK.
(Start - Settings - Control Panel - Regional Options - General and Date Tab)
I tried a lot of options like Tools - options, Insert - date, Format –field. But I could not change the merged field format from mm/dd/yy to dd/mm/yy. Finally here is how I managed it.
1) Right click on the field and choose "Edit Fields..."
2) Click on Field Codes
3) You will see the line something like this: MERGEFIELD Issue_Date You have to add the date format like this: \@ "dd/MM/yyyy"

... Comment

Only the latest Office version

I have just tested it using Word 2000 and it seems that only Word 2002 is affected by this feature. Actually Word 2002 has much more features. But sometimes less is better!

... Link


... Comment
A Bug

I tried the formula mentioned above and it turned out to be bug in the latest version of office! It changed the Month where the date was more than 12. It means it changed 3/31/04 to 31/3/04 but did not changed 3/8/04 to 8/3/04.
I had to change the dates format to text. (Copy date column - From Data - Text to column - Text format)

... Link

Mail Merge - Date Formats

I tried the "Data" - "Text to Column" conversion in Excel and it works when you do a Mail Merge to word. I had 1400 form letters to do and after trying various formats this is the only one that worked!!
Thanks!!

... link

Mail Merge - Date Formats

How do you do the "Date" - "Text to Column" conversion? Is it the same as changing the date format of a cell to a text format in Excel?

... link


... Comment

Online for 6605 days
Last modified: 4/12/20 2:01 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
September 2020
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
27282930
April
Recent updates
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 10:28 AM)
backup mysql users  3
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20 2:41 PM)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 12:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 11:49 AM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 10:40 AM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher