Reply
 
Thread Tools Display Modes
  #1   Report Post  
J.A.Hamilton2011 J.A.Hamilton2011 is offline
Junior Member
 
Posts: 1
Default Merging Excel 2007 into Word - need number to appear as percentage

Is there a switch I can add to a merge field that will format a number (pulled from Excel spreadsheet) into a percentage? I successfully used the switch to format a number into dollars (thank you Connie Miller) but now need to format one number as a percentage. When it pulls from Excel I'm getting the .1467897 format (for example), but what I need is 15% format. Thanks for the help!
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
Converting Percentage to whoel number promomatters Microsoft Word Help 0 September 29th 10 11:25 PM
format field percentage merge Word 2007 from excel 2007 LoisInAlaska Mailmerge 3 September 15th 08 06:47 PM
How can I maintain Excel's number formatting when merging to Word? jenniferb Mailmerge 7 May 1st 08 04:45 AM
Mail merge: merging number from excel to word. Aom Microsoft Word Help 3 June 2nd 06 03:17 PM
mail merge a percentage from excel into a word Avani Mailmerge 1 April 8th 06 06:36 AM


All times are GMT +1. The time now is 01:45 AM.

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"