Format Cells

From prevero Competence Center
Jump to: navigation, search
Last update: 09/2012

Opening path[edit]

Up to Professional Planner 2011

  • Menu: Format\Cells
  • Shortcut menu in document: Format cells...
  • Design mode: button Format cells


Starting with professional planner 8

  • Format Tab - Section "Cells": Format - Format Cells...
  • Context menu in document: Format cells...


Number tab[edit]

In the Number tab you can choose from a set of predefined number formats. However, you can also define your own number formats. The following options are available:


  • #: Displays only significant digits. Insignificant zeros are ignored.
  • 0 (Zero): Displays insignificant zeros if a number has fewer digits than there are zeros in the format.
  • ?: Adds blank spaces for insignificant zeros on both sides of the decimal point so that decimal points align when formatted with a fixed-width font, e.g. Courier New. You can also use question marks for fractions with a varying number of digits.


Decimal places and significant digits[edit]

To format fractions or numbers with decimal places, enter the following digit wildcards in a section. If a number has more digits to the right of the decimal point than there are wildcards in the format, the number is rounded to as many decimal places as there are wildcards. If there are more digits to the left of the decimal point than there are placeholders, the extra digits are also displayed. If the format contains only numbers (#) after the decimal point, the figures lower than 1 begin with a decimal point.


Number format Code
1234.59 as 1234.6 ####.#
8,9 as 8,900 #,000
,631 as 0,6 0,#
12 as 12,0 and 1234,568 as 1234,57 #,0#
44.398, 102.65 and 2.8 with aligned decimal places  ???.???
5.25 as 5 1/4 and 5.3 as 5 3/10 with aligned division symbols # ???/???


Thousands separator[edit]

To display a comma as a thousands separator, or to scale a number multiplied by one thousand, you can include a comma in the number format.

Number format Code
12000 as 12.000 #.###
12000 as 12 #.
12200000 as 12,2 0,0..


Colors[edit]

To set the color for a section of the format, enter one of the following eight colors in square brackets. The color code must be the first item in the section.

[Black];[Blue];[Cyan];[Green];[Magenta];[Red];[White];[Yellow]

Apart from the eight default colors, you can display any color from the color palette. [Color1] means the first color in the first row of the palette. [Color9] is the first color in the second row of the palette, etc.


Conditions[edit]

The number format in Professional Planner is structured like this:

1st section positive values
2nd section negative values
3rd section zero values
4th section N.V. values

In order to define number formats that will only be applied if a number meets a specified condition, enclose the condition in square brackets. The condition consists of a comparison operator and a value. For example, the following format displays the numbers less than or equal to 100 in red and numbers greater than 100 in blue.

[Red][<=100];[Blue][>100]


Alignment tab[edit]

In the Alignment tab you can align the number values in cells vertically or horizontally. If you select a range of cells, you can merge this range into one cell.


Font tab[edit]

Here you can choose a font and change its color and size. In addition, you can select a script. This is necessary, if you do not use the Western character set, but instead e.g. Cyrillic or Greek.


Border tab[edit]

In the Border tab you can select different borders, line styles, line colors etc.


Patterns tab[edit]

Use the tab Patterns to change colors, apply a texture or pattern to the background or to the individual cells.