Thread: [Solved] Add a comma
View Single Post
 
Old 06-06-2014, 05:30 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
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