The Format tab enables you to specify the format to be used for certain fields.
What do you want to do?
The Format tab enables the user to specify the format to be used for the following fields:
Date: the default Windows formats are proposed in the Type drop-down combo box however, you can enter your own format. The formats available are as follows:
d/m: day/month. For example, displays 3/7 for July 3.
d/m/yy: day/month/last two year digits. For example, displays 3/7/08 for July 3 2008.
d/mm/yy: day/monthmonth/last two year digits. For example, displays 3/07/08 for July 3 2008.
d-mmm: day - first three month letters. For example, displays 3-Jul for July 3.
d-mmm-yy: day-first three month letters-last two year digits. For example, displays 3-Jul-08 for July 3 2008.
dd-mmm-yy: dayday-first three month letters-last two year digits. For example, displays 03-Jul-08 for July 3 2008.
mmm-yy: first three month letters-last two year digits. For example, displays Jul-08 for July 2008.
mmmm-yy: print the full month name-last two year digits. For example, displays July-08 for July 2008.
d mmmm yyyy: day print the full month name and year digits. For example, displays 3 July 2008 for July 3 2008.
Time: the default Windows formats are proposed in the Type drop-down combo box however you can enter your own format. The formats available are as follows:
h:mm: for hour:minutes.
h:mm AM/PM: for hour:minutes AM (morning), PM (afternoon).
h:mm:ss: for hour:minutes:seconds
h:mm:ss AM/PM: for hour:minutes:seconds AM (morning), PM (afternoon).
TimeStamp: the default Windows formats are proposed in the Type drop-down combo box however, you can enter your own format. The formats available are as follows:
dd/mm/yy hh:mm:ss: for day digits/month digits/last two year digits hour:minutes:seconds. For example, displays 03/07/08 14:22:16 for July 3 2008 at 2:22 PM and 16 seconds.
dd/mm/yy hh:mm:ss:nnn: for day digits/month digits/last two year digits hour:minutes:seconds. For example, displays 03/07/08 14:22:16:123 for July 3 2008 at 2:22 PM and 16 seconds and 123 nanosceonds.
dd/mm/yy hh:mm:ss:nnnnn or day digits/month digits/last two year digits hour:minutes:seconds. For example, displays 03/07/08 14:22:16:12345 for July 3 2008 at 2:22 PM and 16 seconds and 12345 nanosceonds.
Number: this is the number representation for numeric fields. the default Windows formats are proposed in the Type drop-down combo box however, you can enter your own format. The formats available are as follows:
0.00: in this case 0 is a placeholder that displays a digit or 0 if there is none.
0.00;-0.00;<Null>: in this case 0 is a placeholder that displays a digit or 0 if there is none
#,##0.00: in this case # is a placeholder that displays a digit or nothing if there is none and 0 is a placeholder that displays a digit or 0 if there is none.
#,##0.00;-#,##0.00;<Null>: in this case 0 is a placeholder that displays a digit or 0 if there is none
