+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Office 2007 Mail Merge Query in Technical; Hi there, within Excel I have a column that has figures in it with . ie 1,200.24 However, when I ...
  1. #1
    bodminman's Avatar
    Join Date
    Apr 2007
    Location
    Sunny Suffolk
    Posts
    1,150
    Thank Post
    722
    Thanked 222 Times in 114 Posts
    Rep Power
    84

    Office 2007 Mail Merge Query

    Hi there,
    within Excel I have a column that has figures in it with . ie 1,200.24

    However, when I try presenting this within a mail merge document the figures just turn into something like 120024.

    Has anyone got any pointers?

    Thanks

  2. #2

    Join Date
    Oct 2010
    Posts
    23
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Blog Entries
    2
    Rep Power
    42
    In Excel, the custom number formatting of your column will be something like
    Code:
    #,##0.00
    To check, press CTRL+1 and select Custom on the Number tab.

    To reproduce this in Word you will need to add the number formatting switch \# to your field code and add the custom number format after it.

    If ExcelColumnOfData is the name of your field, you should end up with something like:
    Code:
    { MERGEFIELD ExcelColumnOfData \# #,##0.00 }
    (ALT+F9 to toggle view the field code in Word.)

    HTH

SHARE:
+ Post New Thread

Similar Threads

  1. 2008 R2 DFS and Office 2003 Mail Merge Problem.
    By bjohnny42 in forum Windows Server 2008
    Replies: 3
    Last Post: 11th January 2011, 04:46 PM
  2. VBA in Word 2007 - to split a mail merge, just one line needed!
    By CaterinaAnna in forum Office Software
    Replies: 2
    Last Post: 9th July 2010, 02:51 PM
  3. Replies: 1
    Last Post: 17th June 2010, 07:24 PM
  4. Mail Merge Office 2003
    By karldenton in forum Windows
    Replies: 5
    Last Post: 18th June 2007, 08:26 AM
  5. Mail Merge with Office 2003
    By luke213 in forum Windows
    Replies: 1
    Last Post: 19th January 2006, 10:33 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •