Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2014, 12:32 PM
mbesspiata mbesspiata is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Advanced Beginner
Add a comma
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Angry Add a comma


I have a column of numbers that need to be merged into a document but the merge does not recognize formatting. How can I get these numbers to show up in the merged document with the comma?

Mike
Reply With Quote
  #2  
Old 06-05-2014, 04:25 PM
gebobs gebobs is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Not exactly clear on what your problem is. What do you mean by "merged into a document"? What comma are you talking about? Can you attach a sample sheet?
Reply With Quote
  #3  
Old 06-06-2014, 05:30 AM
mbesspiata mbesspiata is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Advanced Beginner
Add a comma
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

Here is part of data to be merged into a word document. I can't give any other information from the row in excel. But the column of PRICE is where we have the value of the vehicle. When it's formatted as a number, it won't carry the comma to the word document. If it's formatted as a text file with the comma, it will carry over the comma. I want something that will take this column and place the comma in the correct position for numbers (and not have a comma if there are only 3 or less characters). Here is the partial row. Hope my explanation helped and thanks for the response.
YEARMAKEMODELBODYCYLPRICECOMPANY NAME2009Mercedes BenzC350Sedan619900Oncar Automotive
Reply With Quote
  #4  
Old 06-06-2014, 07:42 AM
gebobs gebobs is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Please attach the files, the Excel data and the Word merge. I haven't done a mail merge in years. You will have to Go Advanced to do that.
Reply With Quote
  #5  
Old 06-06-2014, 08:33 AM
mbesspiata mbesspiata is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Advanced Beginner
Add a comma
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

I'm sorry. I'm making this more difficult than it really is. Let's forget about the mail merge. What I really want is a formula or macro code to take the column with the values under price (in text format) and add the commas to those numbers in the proper place. Is that possible?
Reply With Quote
  #6  
Old 06-06-2014, 06:53 PM
ScottA ScottA is offline Add a comma Windows 7 64bit Add a comma Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default

Mike -

I sounds to me that your merge just needs a picture switch to get your data to display the way you want it to.
Once you have set up your document with the merge as you would like it, just highlight your Price field then Press Shift-F9 to display the merge code.

You should see something like this: {MERGEFIELD Price}

Click right between the e and }. Type a space then "\# #,###"

Like this: {MERGEFIELD Price \# #,###}

Here is a link that will give you more info if that doesn't do it:

Muck around with field codes


Scott

See Example
Attached Files
File Type: docx Car Merge.docx (16.1 KB, 5 views)
File Type: xlsx CarMergeData.xlsx (8.7 KB, 3 views)

Last edited by ScottA; 06-06-2014 at 07:09 PM. Reason: See Example:
Reply With Quote
  #7  
Old 06-06-2014, 07:22 PM
ScottA ScottA is offline Add a comma Windows 7 64bit Add a comma Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default

BTW - Since your really talking about a merge expect that this topic will probably be moved.
Reply With Quote
  #8  
Old 06-09-2014, 03:36 AM
mbesspiata mbesspiata is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Advanced Beginner
Add a comma
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

Great. Thanks for your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a comma Suppress comma in "city , stat zip" line when blank DHammer Mail Merge 1 05-30-2014 02:43 AM
Add a comma Comma style without trailing zeroes but with decimal part Scaffold Excel 3 10-22-2011 11:08 PM
Adding comma to a custom type. mcook Excel 1 08-13-2011 03:08 AM
adding a comma in end of each line in word juanb007 Word 0 07-23-2010 01:28 PM
Add a comma thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM


All times are GMT -7. The time now is 04:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft