Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
cheers Graham i should have read your reply as you have already given the
solution. "Graham Mayor" wrote: You have a typo there Bob - it should be MERGEFIELD. ![]() -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Bob Fortune wrote: If you enter the calculated field as follows Crl F9 to obtain the first {} then type = between the bracket followed by another Crl F9 {={}} next type MERGEDFIELD Amount between the enclosed brackets. followed by * 100 \#"0%. It important you don't input the brackets from the keyboard Hope this is some help Bob Fortune See http://homepage.swissonline.ch/cindy...002/MM2002.htm or http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Roberta" wrote in message ... I viewed the help in another posting and tried it. It solved the problem of hainalm the decimals but I need it to dispay as 75% not 0.75. Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"} Souce document shows in cell 75% and is formatted as a percentage with no decimals. Merged results: Van 0.75 Desired results Van 75% Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Labels using Mail Merge with data from Excel | Mailmerge | |||
Difficulties mail merging special characters from excel to word 20 | Mailmerge | |||
How do I set sup a mail merge from Excel to Word if the system ca. | Mailmerge | |||
mail merge using excel spread looses the format for social securit | Mailmerge | |||
How do you set up a label mail merge with Excel as source in 2003. | Mailmerge |