Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rone
 
Posts: n/a
Default Merge with Percentage field looses formatting

I'm having difficulty getting a percentage field from and Excel sheet to
properly format when I merge it with Word. I've had no problems getting
currency fields to format, but for some reason I can't get the percentages to
format right.

Here is the switch code I'm using: {MERGEFIELD "CAM_PERCENT" * 100
\#"##.##%"} This displays .0388% But I want it to display 3.88%. I've
also tried using 0's and moving the decimal around, but it hasn't helped me
any. I saw somewhere where someone used \#"0%", but this only displays '0%'
when merged.

I'm a bit new to this switching stuff. Does my version of Word have
anything to do with this? Its Word 2003 Professional v. 11.5604

Thanks for the help
--
Rone
 
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
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Suppressing Merge Field and text before/after julie Microsoft Word Help 8 November 14th 05 02:50 PM
Formatting merge fields: inserting a paragraph mark before a field Justin Cascio Mailmerge 1 August 30th 05 08:18 PM
How do I omit an empty date merge field? Phildeman Microsoft Word Help 5 June 13th 05 03:29 PM
Formatting a percentage mail merge field Kylor Microsoft Word Help 5 March 18th 05 07:04 PM


All times are GMT +1. The time now is 12:40 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"