Note:Excel2007 output (.xlsx) doesn't support the following format masks: E, EE, W, WW, X, XX. Displays the literal value of any string between two " characters. Displays the literal value of any string between two ' characters. / - The default date separator defined in DateSeparator. ![]() : - The default time separator defined in TimeSeparator.zzz - Displays the time zone offset for the system's current time zone in hours and minutes.(This element can be used for formatting only) zz - Displays the time zone offset for the system's current time zone in whole hours only.z - Displays the time zone offset for the system's current time zone in whole hours only.tt - The AM/PM designator defined in AMDesignator or PMDesignator, if any.fffffff - Displays seconds fractions represented in seven digits.ffffff - Displays seconds fractions represented in six digits.fffff - Displays seconds fractions represented in five digits.ffff - Displays seconds fractions represented in four digits.fff - Displays seconds fractions represented in three digits.ff - Displays seconds fractions represented in two digits.f - Displays seconds fractions represented in one digit.Single-digit seconds do have a leading zero. Single-digit seconds don't have a leading zero. Single-digit minutes have a leading zero. Single-digit minutes don't have a leading zero. Single-digit hours don't have a leading zero. This pattern is ignored if the date to be formatted doesn't have an associated period or era string. If the year without the century is less than 10, the year is displayed with a leading zero. MMM - The abbreviated name of the month, as defined in AbbreviatedMonthNames.Single-digit months don't have a leading zero. dddd - The full name of the day of the week, as defined in DayNames.ddd - The abbreviated name of the day of the week, as defined in AbbreviatedDayNames.Single-digit days don't have a leading zero. ![]() If you don't specify the mask in the Date format field, then the abstract format mask "MEDIUM" is used as default. S (after number) - Displays positive value with a trailing "+" and negative value with a trailing "-".S (before number) - Displays positive value with a leading "+" and negative values with a leading "-".PT - Displays negative value enclosed by ().PR - Displays negative value enclosed by.MI - Displays negative value with a trailing "-".L - Returns the local currency symbol in the specified position.For example: Format mask: 9G999D99 Data: 1234.56 Display for English locale: 1,234.56 Display for German locale: 1.234,56 The grouping separator symbol used is determined at runtime based on template locale. G - Determines the placement of the grouping (thousands) separator.EEEE - Returns a value in scientific notation.The decimal separator symbol used is determined at runtime based on template locale. D - Determines the placement of the decimal separator. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |