[Louise]

I am working with Excel 2003 and a large database. Part of what I am doing
involves makeing labels that include name and birthdate and SIN number.
After making my list with the birthdate formatted to dd-Apr-yyyy and sin 000
-000-000, when I go to Word to do labels, these two formats do not stay in
the column. They become dd/mm/yy and 000000000.
When I first started doing this, it was OK but now it is not working right.
Did I do something to cause it not to stay?
If I print the list as a list it stays as I want it, just not when I try to
do labels.
I am wondering if it could be that my computer is part of a large network.
I had just been saving the database to the desktop then I started saving it
to the main drive on the network so I wouldn't loose all the work I have done
as it is saved each night and it seems to have started after that.
A new Excel page saved to the desktop does the same thing.

[Graham Mayor]

There is nothing unusual about this - apply the switches that will give you
the layout you want to the merge fields -
http://www.gmayor.com/formatting_word_fields.htm

\@ "dd-MMM-yyyy"
and
\# "000'-'000'-'000"
respectively

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Louise wrote:
I am working with Excel 2003 and a large database. Part of what I am
doing involves makeing labels that include name and birthdate and SIN
number. After making my list with the birthdate formatted to
dd-Apr-yyyy and sin 000 -000-000, when I go to Word to do labels,
these two formats do not stay in the column. They become dd/mm/yy and
000000000.
When I first started doing this, it was OK but now it is not working
right. Did I do something to cause it not to stay?
If I print the list as a list it stays as I want it, just not when I
try to do labels.
I am wondering if it could be that my computer is part of a large
network.
I had just been saving the database to the desktop then I started
saving it to the main drive on the network so I wouldn't loose all
the work I have done as it is saved each night and it seems to have
started after that.
A new Excel page saved to the desktop does the same thing.