Cơ sở công nghệ thông tin UEH - Đề ôn nhập liệu và bài thực hành 2

\* Caps : Capitalizes the first letter of each word. (Is the equivalent of 'Title Case' in the Change Case list.) \* FirstCap : Only the first letter of the first word is capitalized. (Is the equivalent of 'Sentence Case' in the Change Case list.) \* Upper : Capitalizes all letters. (Is the equivalent of 'Uppercase' in the Change Case list.) \* Lower : Transforms all letters to lowercase. (Is the equivalent of 'Lowercase' in the Change Case list.) Date and Numeric Format Examples The following table includes formatting examples for the date and number types mail merge fields. Field Format Merge Field Syntax To use standard date formatting: 10/26/2012 {MERGEFIELD Invoice.InvoiceDate} To use simple date formatting: 20121026 {MERGEFIELD Invoice.InvoiceDate \@ yyyyMMdd} To use text date formatting: OCT 2012 {MERGEFIELD Invoice.InvoiceDate \@ MMM yyyy} To use standard percentage formatting: 0.08 {MERGEFIELD TaxItem.TaxRate} To use percentage symbol formatting: 8% {MERGEFIELD TaxItem.TaxRate \# ##%} To specify a label for a quantity: 3.0000kg {MERGEFIELD Usage.Quantity \# #,##0.0000kg} To specify a symbol for a currency: €12,13.8 {MERGEFIELD Invoice.Total \# €#,#0.0}