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 6084 days
Last modified: 3/30/19 6:52 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
April 2019
SunMonTueWedThuFriSat
123456
78910111213
14151617181920
21222324252627
282930
March
Recent updates
schema conversion tool This seems
to be a useful tool to convert mysql or oracle...
by shantanuo (3/30/19 6:52 AM)
Install packetbeat In order to
install packetbeat, you may need to change the windows security...
by shantanuo (3/26/19 8:01 AM)
python itertools module from itertools
import groupby s = 'abcccccbba' for w, v in groupby(s):...
by shantanuo (3/17/19 3:22 PM)
audio visual modules for Machine
Learning Here is the list of some of the modules...
by shantanuo (3/16/19 1:08 PM)
google module module for google
search !pip install google from googlesearch import search for url...
by shantanuo (1/8/19 10:38 AM)
Python date and time from
datetime import datetime date_string = "21 June, 2018" date_object =...
by shantanuo (12/26/18 12:14 PM)
Infer types in pandas This
will return the mixed datatypes but this can be slow....
by shantanuo (12/16/18 3:50 PM)
Extract words from Marathi wikipedia
1) Download the polyglot pickled marathi model wget http://bit.ly/12FI1xV mv...
by shantanuo (11/4/18 10:06 AM)
Google Input tools Google suddenly
stopped download of Input Tools package without giving any reason....
by shantanuo (9/10/18 7:44 AM)
Python objects and methods Here
are important python objects and their methods int __mul__, __add__,...
by shantanuo (8/18/18 3:11 PM)
JSON to DF Here is
how to read a JSON file into pandas dataframe. import...
by shantanuo (8/8/18 1:12 PM)
managing servers using python Fabric
is a high level Python library designed to execute shell...
by shantanuo (8/4/18 10:01 AM)
backup mysql users It is
easy to backup mysql users - wget percona.com/get/pt-show-grants; perl pt-show-grants
by shantanuo (5/20/18 3:42 PM)
About python 1 everything is
an object (class instances) 2 methods depends upon class of...
by shantanuo (5/20/18 2:52 PM)
mysql and shell command date
-d"-1 day ago" +'%b%d' equals to mysql -Bse"select date_format(date(date_add(now() ,...
by shantanuo (5/16/18 7:47 AM)
Preserving comments in Stored Procedure
You can write multi line comments in a stored procedure...
by shantanuo (5/12/18 12:56 PM)
Custom slack command Here are
5 steps to add any API to your slack channel....
by shantanuo (4/25/18 6:59 AM)
stack bookmarklet This bookmarklet will
help to quickly access stack pages linking to current page...
by shantanuo (1/10/18 10:47 AM)
Manage S3 like rsync ####
create bucket aws s3 mb s3://johntest123/ #### rsync all files...
by shantanuo (12/22/17 12:04 PM)
apache docker container issues If
apache docker container does not start then make these changes......
by shantanuo (11/10/17 3:00 PM)
Install aws client on centos
If pip is not installed, then the following command will...
by shantanuo (10/26/17 9:51 AM)
Managing Amazon keys Use this
command to convert private key to public key. ssh-keygen -y...
by shantanuo (10/9/17 7:04 AM)
percona utility We can re-create
mysql users using the percona utility. wget percona.com/get/pt-show-grants chmod 777...
by shantanuo (9/6/17 8:22 AM)
mail merge separate file per
record Microsoft Word has an excellent feature called Mail-Merge. If...
by shantanuo (7/6/17 12:09 PM)
find dead processes The 8th
column of ps aux command will list the status of...
by shantanuo (5/28/17 7:39 AM)

RSS feed

Made with Antville
Helma Object Publisher