Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2014, 05:30 AM
mbesspiata mbesspiata is offline Add a comma Windows 7 64bit Add a comma Office 2010 64bit
Advanced Beginner
Add a comma
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a comma Suppress comma in "city , stat zip" line when blank DHammer Mail Merge 1 05-30-2014 02:43 AM
Add a comma 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
Add a comma thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft