![]() More difficult even for people who prefer Word: Microsoft Office Assistance: Answer Box: Numbers don't merge right in Word, by Connie Miller Or with a more generic function that simplyįor people comfortable with MS Word macros and particularly for Excel 2003 users and others who don't want to do anything in Excel to change formatting you can change things in Word though I expect these methods are If the sheet is strictly to provide data to Mail Merge then use ofĪ helper column would have very little impact on your data. You can use a helper column to provide the text values of the numbers to be used You can convert things in place to text such as zip codes which should have been defined as text anyway and not as numbers with a macro fix zip codes - see below in several places macro fixUSzip5 will convert them to text. See in Excel you can run the AllCellsToText macro whichĬreates a copy of the worksheet with All Cells Converted to Text Values asĭisplayed in Excel (. If you want to make sure that Mail Merge displays text exactly the same as you You may not be able to do this if some of your zipcodes are actually entered as numbers of less than five digits. Should you need to split out zip codes for sorting. Failure to do this will result inĥ digit numbers being zero suppressed and treated as numbers which sortīefore text entries of 9 digits with a hypen. Numbers not Rendering correctly in Mail Merge (#rendering)įormat the entire Excel sheet as text (#text, suggestion) so that zipcodes will be Avery form 5395 (Name Tags) and suggest you show the ruler so you can see horizontal area/pattern of labels.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |