#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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?
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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.
|
#5
|
|||
|
|||
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?
|
#6
|
|||
|
|||
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 Last edited by ScottA; 06-06-2014 at 07:09 PM. Reason: See Example: |
#7
|
|||
|
|||
BTW - Since your really talking about a merge expect that this topic will probably be moved.
|
#8
|
|||
|
|||
Great. Thanks for your help.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Suppress comma in "city , stat zip" line when blank | DHammer | Mail Merge | 1 | 05-30-2014 02:43 AM |
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 |
thousands comma separator | taylormayd | Excel | 3 | 02-20-2009 03:46 AM |