Taken from http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm
When using Excel spreadsheets in a mail merge process, many users frequently run into difficulty formatting the fields that contain number values. To ensure the data contained in the fields is inserted correctly, one must format the field, not the data in the source file; unfortunately, Word does not provide a way for you to change how many decimal places are displayed when working with numbers. While there are ways to work around this limitation, the best solution is to include a switch in the merge field.
To specify how many decimal places to display in your Word mail merge, you can use the Numeric Picture Field Switch (\#):
1. With the mail merge main document open, press Alt + F9 to view the field codes
2. The field code will look something like {MERGEFIELD “fieldname” }
3. Directly after the end quote around the field name type \# -- do not add spaces or quotes
4. Directly after the field switch you just entered, type 0.0x if you want to round the number to two decimal places, 0.00x if you want to round the number to three decimal places and so forth
5. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes
Your number will appear rounded to the decimal place you specify; if it does not display immediately, refresh the document by minimizing it to the toolbar and reopening. If the field value still does not display correctly, you may need to refresh the document again or close and re-open your document.
【诗巫景Ho-Liak】吃晚饭的不错选择@新龙婆海鲜酒家
-
想找一个不错的餐厅和家人或宴请亲戚朋友吃晚餐?个人建议这间坐落于诗巫中央警局后方的新龙婆海鲜酒家。之前它在江滨公园对面的龙婆茶餐室营业已经获得本地人的好评,现在搬到现有的地址营业,生意还是持续的门庭若市。
现在这地点跟之前的比起来,停车位比较方便,而且有更大的营业空间。餐馆分为两层楼。底楼是开放式的,而一楼就备有...
6 years ago
No comments:
Post a Comment