Thread: [Solved] Add a comma
View Single Post
 
Old 06-06-2014, 06:53 PM
ScottA ScottA is offline Windows 7 64bit 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, 11 views)
File Type: xlsx CarMergeData.xlsx (8.7 KB, 9 views)

Last edited by ScottA; 06-06-2014 at 07:09 PM. Reason: See Example:
Reply With Quote