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
|