Word XP Field Formats

[John Baigrie]

Help! We have recently upgraded from Office 97 to XP and
are having difficulties with a merged document. The data
source changes month on month, but the fields stay the
same. Two problems have been happening since upgrade.

Firstly, Word wants to select all 65000 records from the
spreadsheet. There are only about 35 rows with data. If I
manually select just the rows I want, when I go back in,
Word has selected them all again.

Secondly, 4 of the fields that are used are currency
amounts. After the conversion, I cannot get word to
view/print the currency details, I just get the basic
numeric values. e.g I want £1234.56 and all I get is
1234.56 or I want £80.00 and I get 80. This is driving me
nuts!

 

[John Baigrie]

Doug, thanks for that. But it has raised another question.
With the field code, how do I get say £ 80.00 so that
the £ sign stays left aligned and the numbers right
aligned like XL deals with accountancy format?

Also, do you have any idea how to stop word looking at all
65,000 records?

Cheers

 

[Cindy Meister -WordMVP-]

Hi John,

But it has raised another question.
With the field code, how do I get say £ 80.00 so that
the £ sign stays left aligned and the numbers right
aligned like XL deals with accountancy format?

You're not going to be able to get Word to do this. Better
would be to leave the £ sign away from the number format and
type it directly into the mail merge document. Then use a
tabstop and tab character to position the number.

Also, do you have any idea how to stop word looking at all
65,000 records?

Do these 35 records have anything in particular in common?
i.e. could you filter them in Excel on some field or other?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[John Baigrie]

Argggg

This mailmerge was originally used in Office 97 and worked
fine there. Why is it that after upgrading I am faced with
Word can't do that when it did before!

Any ideas anyone?

 

[Cindy Meister -WordMVP-]

Hi John,

I doubt very much that Word97 (or any version) aligned a
currency symbol left (or right) in a cell, and the number at
the other side. Word just can't do this; that's Excel
functionality.

Or perhaps I'm misunderstanding what you mean by "how do I
get say £ 80.00 so that the £ sign stays left aligned and
the numbers right aligned like XL deals with accountancy
format?" ?

Argggg

This mailmerge was originally used in Office 97 and worked
fine there. Why is it that after upgrading I am faced with
Word can't do that when it did before!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail