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 - 09 Jun 2007 17:30 GMT
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

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> 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
[quoted text clipped - 13 lines]
> started after that.
> A new Excel page saved to the desktop does the same thing.