LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Excel Mail merge two word

When there is a percentage on the Excel form it comes out as a decimal with
numbers to the right when all I want is it to read 31%. I found from another
question/answer what seems to be how I fix this but I don't know where to put
this particular formula. What was written as a fix is,

Percentages

Frequently, percentages will display as decimals - e.g. 41% from the data
may display as 0.41354836739 when merged into Word. To display the decimal as
a percentage, you should create a calculated field e.g.:

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

From my understanding this will make it show up on the word document as 41%
instead of 0.41354836739. Where do I put this formula?

Thanks in advance for anyone's help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge a Date from Excel to Word Steve Excel Discussion (Misc queries) 1 October 25th 06 12:15 AM
mail merge from Excel to Word sumplug Excel Discussion (Misc queries) 2 August 17th 06 05:18 PM
how do I use mail merge in excel for word documents Lisa J Duffy Excel Discussion (Misc queries) 1 August 4th 05 01:40 PM
Merge mail excel to word T. Rebouche Excel Discussion (Misc queries) 2 February 21st 05 11:05 PM
Word mail merge with Excel data Bailey Excel Worksheet Functions 2 January 30th 05 09:19 PM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"