Problem with \@

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GastonFranzini@gmail.com - 05 Dec 2006 14:42 GMT

Hi,
I have a problem, the mail merge field is not formating as I'm
expecting.
Not all the column have dates, but I want the fields with dates to show
as dd/MM/yy not number.
Any help is valuable.
Thanks

Reply to this Message

Graham Mayor - 05 Dec 2006 14:55 GMT

We had this discussion last month - the issue is still the same. Go back and
read your previous thread.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hi,
> I have a problem, the mail merge field is not formating as I'm
[quoted text clipped - 3 lines]
> Any help is valuable.
> Thanks

Reply to this Message

GastonFranzini@gmail.com - 05 Dec 2006 15:29 GMT

I have already and all the rest is working fine.
The problem now is that I don`t have just dates in the source column.
In the columns that I have only dates it works fine.
I have discovered that If I change the regional settings the formating
stops working.

Thanks for your help.

Reply to this Message

Graham Mayor - 05 Dec 2006 15:46 GMT

You are making things very difficult for yourself by mixing data types in
the same field. It would make sense to add another column to separate out
the numbers from the dates, which is much easier to do in Excel than Word.
You can then use a conditional field check on that column to establish
whether it contains a number or zero then insert this new field or the date
field accordingly.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I have already and all the rest is working fine.
> The problem now is that I don`t have just dates in the source column.
[quoted text clipped - 3 lines]
>
> Thanks for your help.

Reply to this Message