Importing a custom format from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Hargreaves - 10 Dec 2003 08:27 GMT

I am using an excel spreadsheet that get's e-mailed to me as the data
source for a form in Word. The first column contains the reference
number, and should be in the format CHP000S000M.

The person at the other end has set this custom format up in Excel so
that they only have to type in the numbers, eg although the cell shows
CHP123S456M when you import to Word, it will only show 123456.

Is it possible to recreate this format in Word, or would I have to
manually change them?

Regards

Andrew H

Reply to this Message

macropod - 10 Dec 2003 09:17 GMT

Hi Andrew,

In your mergefield, add the following picture switch before any other
switches:
\# "CHP000S000M"
so that your field looks something like:
{MERGEFIELD Data \# "CHP000S000M"}

Cheers
PS: The 0s are zeros, not letters O.

> I am using an excel spreadsheet that get's e-mailed to me as the data
> source for a form in Word. The first column contains the reference
[quoted text clipped - 10 lines]
>
> Andrew H

Reply to this Message

harg7769@lineone.net - 10 Dec 2003 09:49 GMT

Thanks for that, I'll give it a go.

BTW Macropod, you're not Alan off the Celtic lhist on Topica are you?

>Hi Andrew,
>
[quoted text clipped - 21 lines]
>>
>> Andrew H

Reply to this Message

macropod - 11 Dec 2003 21:06 GMT

Nope.

> Thanks for that, I'll give it a go.
>
[quoted text clipped - 25 lines]
> >>
> >> Andrew H

Reply to this Message

Graham Mayor - 10 Dec 2003 09:28 GMT

This is Office 2002/3 right? - see the Excel Data section at :
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am using an excel spreadsheet that get's e-mailed to me as the data
> source for a form in Word. The first column contains the reference
[quoted text clipped - 10 lines]
>
> Andrew H

Reply to this Message