Specifying decimal places in a data table

Print this Topic

How do you change the number of decimal points in a data table?

Prism automatically chooses the number of decimal points to display in a data table automatically.

To change the number of decimal points displayed:

1.Select the column or columns you wish to change (click at the top of the column to highlight)

You can only change numerical format for an entire column (or several columns). It is not possible to change the numerical format of individual cells.

2.Click on the Change decimal format button of the Change toolbar.

3.Uncheck “Automatically increase as needed” if you want to manually specify the number of digits to show after the decimal points. You also can use this tool to tell Prism when to use scientific notation.

Note: When you place the insertion point (click the mouse cursor) in a particular cell in a data table, Prism expands that value to show all digits. When you move to another cell, the value reverts back to the selected numerical format.

Decimal separator

In some parts of the world, a period (point) is used as the decimal separator. In other parts of the world, a comma is used.

When entering data into Prism, you can use either a period or a comma to mark the decimal point.

When exporting data, Prism uses the separator you choose in Preferences.

When importing data, you can specify how a comma is interpreted (as a decimal separator, as a thousands separator, or to separate columns of data).



Copyright (c) 2007 GraphPad Software Inc. All rights reserved.
URL: http://www.graphpad.com/help/Prism5/Prism5Help.html?using_decimal_format.htm