Solved

How to format multiline numeric merge fields

Posted on 2009-05-19
8
598 Views
Last Modified: 2012-05-07
Hi there,

I have a field that contains multiple dates on separate lines. When this contains only one date, my merge field works fine with the following...

{MERGEFIELD "TheVals" \#"£0.00"}
which returns £89.75

but if there are more than one value in there, it does something very odd.....

If the merge field contains...
12.99
1.50
2.50

...what it returns is....
£16.99

So the formatting worked, but it totalled everything.

If I have the merge field in there without the formatting formulae, it just returns the values one under the other thus....
12.99
1.50
2.50

Any ideas would be gratefully received!

Cheers,
Matt
0
Comment
Question by:PolymorphLtd
  • 4
  • 2
8 Comments
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Hi,
You won't be able to do the formatting in the document.You'll need to add the "£" sign to the data.

Gary
0
 

Author Comment

by:PolymorphLtd
Comment Utility
Hi there,

Annoyingly, the pound sign is in the data, Word strips it out (and any trailing zeros after the decimal point) which is why I've had to put the formatting formula in.

My datasource is an HTML file containing a table

Cheers,
Matt
0
 

Author Comment

by:PolymorphLtd
Comment Utility
eg. In the datasource, I've got the following...

<TD>£1000.00<br>£0.00<br>£25.00<br>£333.33<br>£33.33<br>£65.50<br>£120.00<br>£18.52<br>£18.52<br>£18.52</TD>

Word correctly interprets it as a multiline value but then insists on removing the pound signs and the trailing zeros
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:PolymorphLtd
Comment Utility
Even more annoying is that Word2007 doesn't remove them but Word2003 does
0
 

Author Comment

by:PolymorphLtd
Comment Utility
Just as a follow up to this - I think we finally fixed it by putting a space between the pound sign and the number in the data i.e. "£ 1200.00" and Word kept it - without the space, Word stripped it
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
It took almost a year but great!
0
 

Accepted Solution

by:
ee_auto earned 0 total points
Comment Utility
Question PAQ'd, 125 points refunded, and stored in the solution database.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now