Custom Fields Format
Custom Fields of Date or Number type can be formatted according to your own preferences.Date Formats
%% a '%' character%a abbreviated weekday name
%A full weekday name
%b abbreviated month name
%B full month name
%c shorthand for "%X %x", the locale format for date and time
%d day of the month as a decimal number (01-31)
%e same as %d but does not print the leading 0 for days 1 through 9 (unlike strftime(), does not print a leading space)
%F milliseconds as a decimal number (000-999)
%H hour based on a 24-hour clock as a decimal number (00-23)
%I hour based on a 12-hour clock as a decimal number (01-12)
%j day of the year as a decimal number (001-366)
%m month as a decimal number (01-12)
%M minute as a decimal number (00-59)
%p AM/PM designation for the locale
%S second as a decimal number (00-59)
%w weekday as a decimal number (0-6), where Sunday is 0
%x date using the date representation for the locale, including the time zone (produces different results from strftime())
%X time using the time representation for the locale (produces different results from strftime())
%y year without century (00-99)
%Y year with century (such as 1990)
%Z time zone name (such as Pacific Daylight Time; produces different results from strftime())
%z time zone offset in hours and minutes from GMT (HHMM)
Number Formats
Format strings can include the following types of characters:Format strings can include numeric characters. Wherever you include a number in a format string, the number is displayed unless an input character in the same relative position overwrites it. For example, suppose you have the positive format string "9,990.00", and the value 53.88 is entered into a cell to which the format has been applied. The cell would display the value as 9,953.88.
Format strings can include the period character (.) as a decimal separator, and comma character (,) as a thousand separator.
You use the pound sign character (#) to represent numeric characters that will be input by the user. For example, suppose you have the positive format "$#,##0.00". If the characters 76329 were entered into a cell to which the format has been applied, they would be displayed as $76,329.00. Strictly speaking, however, you don't need to use placeholders. The format strings ",0.00", "#,#0.00", and "#,##0.00" are functionally equivalent. In other words, including separator characters in a format string signals iCDc to use the separators, regardless of whether you use (or where you put) placeholders. The placeholder character's chief virtue lies in its ability to make format strings more human-readable.
To include a space in a format string, use the underscore character (_). This character inserts a space if no numeric character has been input to occupy that position.
The dollar sign character ($) is normally treated just like any other character that doesn't play a special role in the format.