Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jeannie McQuaid Jeannie McQuaid is offline
external usenet poster
 
Posts: 2
Default Can't get switch to work on numerical data merged to Word from XL

I'm using an Excel sheet to populate merge fields in a Word document.
Despite assorted attempts to put a picture switch on the field according to
the help directions, Word insists on dropping trailing zero's after the
decimal, e.g. $27.60 is displayed 27.6 The date in Excel is formatted
#,###.00 but Word Help says that's irrelevant.

ALT F9 displays {MERGEFIELD "F26"}
To no avail, I've tried: {MERGEFIELD "F26" #\ #,###.00}; {MERGEFIELD
"F26" \# $#,###.00} just like the help instructions; and more creatively,
{MERGEFIELD "F26" }#\ #,###.00.

What am I doing wrong?

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM
CPU Usage When working with a Template I Created KM1 Microsoft Word Help 6 May 24th 05 04:38 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM


All times are GMT +1. The time now is 08:03 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"