Reference: Formatting spreadsheets
To create a uniform look for notebooks, Quattro Pro has default styles available. Quattro Pro also has numeric format codes, date format codes, and time format codes which can be used to set conditions.
You can type codes in a header or footer to add items such as page numbers and dates instead of adding them from the property bar. For example, when you type text in a header or footer, you can use the bar character (|) to change the text alignment from the left to either centered or right-aligned. On some keyboards, the vertical bar character appears broken in the middle.
If you want to type a number sign (#) or an at sign (@) as a symbol and not as a header or footer code, type a backslash ( \ ) in front of the symbol. For example, typing \@ displays @.
Styles available in Quattro Pro
|  |
The following is a list of default styles available in Quattro Pro.
|
Style
|
Result
|
|
Comma
|
Sets the numeric format to a comma with two decimals
|
|
Comma0
|
Sets the numeric format to a comma with no decimals
|
|
Currency
|
Sets the numeric format to currency with two decimals
|
|
Currency0
|
Sets the numeric format to currency with no decimals
|
|
Date
|
Sets the numeric format to user-defined (with the date format specified)
|
|
Fixed
|
Sets the numeric format to fixed with two decimals
|
|
Heading 1
|
Sets the font to Arial (or Helvetica) 18-point bold
|
|
Heading 2
|
Sets the font to Arial (or Helvetica) 12-point bold
|
|
Normal
|
Sets the numeric format and alignment to general; sets the font to Arial (or Helvetica) 10-point regular; sets shading to white; turns on protection; and sets the text color to black
|
|
Percent
|
Sets the numeric format to percent
|
|
Total
|
Inserts a double line above the active cell
|
Numeric format codes
| |
The table below outlines and describes each numeric format code available in Quattro Pro.
|
Numeric format code
|
Description
|
|
0
|
Always displays a digit. If the number does not have a digit in this position, a zero displays. If there are more digits in the number than zeros in the format code, extra digits in the integer portion are displayed and the fraction portion is rounded.
|
|
9
|
Displays a digit if the number has one. If there are more digits in the number than nines in the format code, extra digits in the integer portion are displayed and the fraction portion is rounded.
|
|
, (comma)
|
Inserts a thousands separator (a comma, unless specified otherwise with the application’s International properties). If not part of a number code, the comma is inserted wherever it is positioned in the format.
|
|
. (period)
|
Inserts a decimal separator (a period, unless specified otherwise with the application’s International properties)
|
|
E- or e-
|
Displays the number in scientific notation, preceding negative exponents with a minus sign. If the format includes at least one zero or nine following this symbol, the number displays in scientific notation with E or e. If the exponent contains more digits than nines or zeros following this symbol, the extra digits are displayed.
|
|
E+ or e+
|
Displays numbers in scientific notation, preceding positive exponents with a plus sign. If the format includes at least one zero or nine following this symbol, the number displays in scientific notation with E or e. If the exponent contains more digits than nines or zeros following this symbol, the extra digits are displayed.
|
|
?//M
|
Displays a fraction followed by the maximum number of digits for the denominator
|
|
?//
|
Displays a fraction followed by the denominator to use. The fraction is not reduced
|
|
?//R
|
Displays a fraction followed by the base denominator to use. The fraction is reduced if possible.
|
|
* (asterisk)
|
Fills the column by r
epeating the character to the right of the asterisk
|
|
_ (underscore)
|
Skips the space that would have been required to display the character that follows the underscore. This lets you align numbers for formats with optional trailing characters, such as negative numbers with parentheses.
|
|
| (bar)
|
Displays the first character following the bar code in the space that would have been required to display the second character following the bar code. This allows the alignment of formats with different trailing characters, such as the K Meg Gig predefined format.
|
|
LeftBar
|
Displays the number as a red horizontal bar starting at the left of the cell using the range 0 to 100.
|
|
CenterBar
|
Displays the number as a red horizontal bar starting in the center of the cell. Uses the range 0 to 100 from the center to the left, and 0 to 100 from the center of the cell to the right.
|
|
RightBar
|
Displays the number as a red horizontal bar starting at the right of the cell using the range 0 to 100.
|
|
General
|
Uses the General numeric format
|
Date format codes
| |
The table below outlines and describes the date format codes available in Quattro Pro.
|
Date format codes
|
Description
|
|
d
|
Displays the day of the month as a one- or two-digit number (1-31)
|
|
dd
|
Displays the day of the month as a two-digit number (01-31)
|
|
wday, Wday, WDAY
|
Displays the day of the week as a four-character abbreviation in lowercase, with the first letter capitalized, or in uppercase.
|
|
1wday, 1Wday, 1WDAY
|
Displays the day of the week as an abbreviation using a number and four-characters in lowercase, with the first letter capitalized, or in uppercase
|
|
weekday, Weekday, WEEKDAY
|
Displays the day of the week in lowercase, with the first letter capitalized, or in uppercase
|
|
mo
|
Displays the month as a one- or two-digit number (1-12)
|
|
mmo
|
Displays the month as a two-digit number (01-12)
|
|
mon, Mon, MON
|
Displays the month as a three-character abbreviation in lowercase, with the first letter capitalized, or in uppercase
|
|
1mon, 1Mon, 1MON
|
Displays the month as an abbreviation using a number and
four-characters in lowercase, with the first letter capitalized, or in uppercase
|
|
month, Month, MONTH
|
Displays the name of the month in lowercase, with the first letter capitalized, or in uppercase
|
|
yy
|
Displays the last two digits of the year (00-99)
|
|
yyyy
|
Displays all four digits of the year (0001-9999)
|
|
* (asterisk)
|
Fills the column by repeating the character to the right of the asterisk
|
|
_ (underscore)
|
Skips the space that would have been required to display the character that follows the underscore. This lets you align numbers for formats with optional trailing characters, such as negative numbers with parentheses.
|
|
| (bar)
|
Displays the first character following the bar code in the space that would have been required to display the second character following the bar code. This lets you align formats with different trailing characters, such as the K Meg Gig predefined format.
|
Time format codes
| |
The table below outlines and describes the time codes available in Quattro Pro.
|
Time format codes
|
Description
|
|
s
|
Displays seconds as a one- or two-digit number (1-59)
|
|
ss
|
Displays seconds as a two-digit number (01-59)
|
|
[ss]
|
Displays a count in seconds that can exceed 60 (for example, formats 00:01:01 as 61 seconds). This format should not be used with year, month, day, hour, or minute codes.
|
|
mi
|
Displays minutes as a one- or two-digit number (1-59)
|
|
mmi
|
Displays minutes as a two-digit number (01-59)
|
|
[mmi]
|
Displays a count in minutes that can exceed 60 (for example, formats 01:01:01 as 61 minutes). This format should not be used with year, month, day, or hour codes.
|
|
h
|
Displays the hour as a one- or two-digit number (1-24). If the format includes am/pm or AM/PM, the number is between 1-12. If am/pm or AM/PM is not included, the 24-hour format (0-24) is used.
|
|
hh
|
Displays the hour as a two-digit number (01-24). If the format includes am/pm or AM/PM, the number is between 01-12. If am/pm or AM/PM is not included, the 24-hour format (00-24) is used.
|
|
[hh]
|
Displays a count of hours that can exceed 24 (for example, formats one day and one hour as 25 hours). This format should not be used with year, month, or day codes.
|
|
.s
|
Displays the decimal portion of seconds (the number of digits to display is specified following this format).
|
|
.mi
|
Displays the decimal portion of minutes (the number of digits to display is specified following this format). This format should not be used with seconds codes.
|
|
.h
|
Displays the decimal portion of hours (the number of digits to display is specified following this format). This format should not be used with minutes or seconds codes.
|
|
a or A
|
Displays a shortened version of am/pm, and sets the time to a 12-hour instead of a 24-hour format in either lowercase or uppercase
|
|
am or AM
|
Displays am/pm in either lowercase or uppercase, and sets the time to
12-hour format instead of 24 hour
|
Header and footer codes
| |
The following table outlines header and footer codes and their function.
|
Code
|
Description
|
|
| (vertical bar)
|
Centers text that follows
|
|
|| (two vertical bars)
|
Right-aligns text that follows
|
|
#p
|
Displays the current page number
|
|
#p+n
|
Displays the current page number plus the number n
|
|
#P
|
Displays the number of pages in the document
|
|
#P+n
|
Displays the number of pages plus the number n
|
|
#d
|
|
|
#D
|
|
|
#ds
|
Displays the current date in Short date format
|
|
#Ds
|
Displays the current date in Long date format
|
|
#t
|
|
|
#T
|
|
|
#ts
|
Displays the current time in Short time format
|
|
#Ts
|
Displays the current time in Long time format
|
|
#f
|
Displays the notebook filename with no path (for example, BUDGET.WB3)
|
|
#F
|
Displays the notebook filename, including the path (for example, C:\DATA\BUDGET.WB3)
|
|
#n
|
Displays the moves to a new line
|
|
# (number sign)
|
Displays the current page number; use for compatibility with Quattro Pro for DOS
|
|
@
|
Displays the current date (as found in your computer’s calendar); use for compatibility with Quattro Pro for DOS
|
Reference: Formatting spreadsheets
Settings