Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sally Sally is offline
external usenet poster
 
Posts: 26
Default Merging excel data into word (2003)

5% in an excel sheet merges to a work doc as 0.05% How do I fix it
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging excel data into word (2003)

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

You will need to multiply the data from the merge field by 100

{ = { MERGEFIELD percent } * 100 \# "0%" }

You must use Ctrl+F9 to insert each pair of field delimiters {}


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"sally" wrote in message
...
5% in an excel sheet merges to a work doc as 0.05% How do I fix it



Reply
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
Merging Data From Excel To Different Formatted Fields In Word Brent E Mailmerge 1 November 4th 06 06:23 AM
Merging Data From Excel Into Different Formatted Fields In Word Brent E Microsoft Word Help 2 November 3rd 06 09:43 PM
Merging data from Excel to Word Paige Microsoft Word Help 2 March 22nd 06 05:59 AM
Losing every other record merging Word doc with Excel Data FlorencePS Mailmerge 2 March 14th 06 02:11 PM
Format Excel data for merging in Word BW Mailmerge 1 January 21st 05 01:25 AM


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

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

About Us

"It's about Microsoft Word"