![]() |
|
|
|
#1
|
|||
|
|||
|
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 |
|
|
|
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 |