Individual Format

Description of individual formatting of the result of a variable

Formatting of results

In most calculations, whether technical or commercial, the calculated values are given uniform symbols. For example, the symbol for the electrical voltage is U. To make the results clearer, RedCrab allows you to assign appropriate formatting to the calculated formula symbols.

For example, if the format for U is set to Prefix and the format string is #V, the result is displayed in volts with prefix


The calculation U=1.5 · 50 = 75
get the formatted result :  U=1.5 · 50 = 75V

The calculation U=0.05 · 0.25 = 12.5 · 10-3
get the formatted result : U=1.5 · 50 = 12.5mV

You can define the formatting individually for a worksheet, or save it in the program settings, making it accessible to all worksheets. There are also a number of predefined formatting options available. To do this, read more in the article Manage Format List.

Defining formatting

This paragraph describes formatting. To do this, open the dialog box by double-clicking on the formula symbol whose result should be formatted; in the example below the P

The top left menu button sets the general format. The button to the right changed the prefix, if the general format Prefix is selected. The combo box on the top changed the decimal places.

In the edit line Format you can input extended result symbols or text. In the example above (#W) the rhombus (#) is the space for the result, the W represent the unit Watt. The chosen general format is Prefix. The display shows: 1.15kW.

Text extensions can be written left or right of the rhombus. The following table shows examples in general mode Prefix

  Results Format Text Result display
  0.012   12m
  0.012 #W 12mW
  0.012 Power:  # W Power: 12 mW
  125 US$ # US$ 125

In the input box Preferred unit you can input a preferred unit of measurement for this variable. For more information about this read the discription of Unit of measurement.