Removing leading zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian - 22 Mar 2004 12:35 GMT

I have a mail merge document with the number field of an address in it.
Unfortunately I think the field is being imported as text and the number
has leading zeros sometimes. I think this because when I try to use the \#
formatting switch it has no effect.

Is it possible to convert this text field to a number field and apply the
\# number fomatting codes to it by editing the merge field code? or is
there another way?

Unfortunately because of the source of this data there is no way of
changing the format before it's mail merged.

Many thanks.

Signature

Ian

Reply to this Message

Graham Mayor - 22 Mar 2004 12:44 GMT

What Word version?
What's the data source?
What is the *exact* switch you are using?
What does the field return without a switch?

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have a mail merge document with the number field of an address in
> it. Unfortunately I think the field is being imported as text and the
[quoted text clipped - 9 lines]
>
> Many thanks.

Reply to this Message

Ian - 23 Mar 2004 13:40 GMT

"Graham Mayor" <gmayor@NOSPAMmvps.org> wrote in news:eSI5PMAEEHA.3472
@TK2MSFTNGP09.phx.gbl:

> What Word version?

2002

> What's the data source?

CSV file

> What is the *exact* switch you are using?

\# "##0"

> What does the field return without a switch?

031 for example and the same with the switch. It appears to ahve no
effect at all.

Thanks for taking an interest.

Reply to this Message

Graham Mayor - 23 Mar 2004 15:46 GMT

I can't reproduce this problem.
I created my own CSV file and use numbers with and without leading zeros.
The only time the zeros appeared was when I omitted the switch.

Try
{MERGEFIELD Number \# "0"}
or
{MERGEFIELD Number \# "#"}
neither of which should allow a leading zero.

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> "Graham Mayor" <gmayor@NOSPAMmvps.org> wrote in news:eSI5PMAEEHA.3472
> @TK2MSFTNGP09.phx.gbl:
[quoted text clipped - 17 lines]
>
> Thanks for taking an interest.

Reply to this Message