The “number” column is a type of column that you can use for choosing and adding dates to your Table Document. Number columns are used for indicating monetary values. If you need to keep track of finances or costs, you can select “number” as the type of column.

The number column has several options for formatting as well. This allows you to save time by using our pre-selected formatting instead of manually making corrections such as adding dollar signs or covert American to European price formatting. Learn more about number columns.

If a column is set to the “number” column type, you can control the exact format of that number in the column. There are two times when you can choose the format of your numbers:

  1. when you add a new column
  2. when you edit your Table Structure

Formatting the date in a new column

When you are adding a new column to your Table Document, you will get a pop-up dialog similar to the one pictured below. First you will need to select “number” as the column type and then you can enter your number parameters into the “Number Format” field:

Learn more about how to select “date” as the column type.

Formatting the date when editing a table

You can use the Table Structure Panel to edit your date column. When you are in the Table Structure Panel you can click on the Extra Type Info cell, which will list the current date format of your date column.

Advanced number formatting

Use the Number Format pop-up dialog to specify:

  • Number Format:
  • specify how many numeric characters are in a “group”. In most numeric systems, numbers to the left of the decimal point are set off in groups of three.
  • specify the number of places to the right of the right of the decimal point to display.
  • Other characters can be added both before and after the number. These will be displayed in the formatted number. For instance, “$0,000.00 per unit” will display the value “1234” as “$1,234.00 per unit” and “1.23” as “$1.23 per unit.”
  • Note: This field requires you to use “0” for numeric placeholders, “,” to indicate grouping, and “.” to indicate the decimal point but the characters specified in the other fields will be the ones that are actually used in the display.
  • Group Separator Character: a single character to be used for “group” separation.
  • Decimal Point Character: a single character to be used to indicate the decimal point.

Formatting Examples

US format:

  • Number Format: “0,000.00” - group by threes
  • Group Separator Character: “,”
  • Decimal Point Character: “.”

Euro format:

  • Number Format: “0,000.00” - group by threes
  • Group Separator Character: “.”
  • Decimal Point Character: “,”

Odd ... format:

  • Number Format: “0,00.00” - group by twos
  • Group Separator Character as space: “ ”
  • Decimal Point Character: “;”

Extra Characters format:

  • Number Format: “$0,000.00 per unit” - group by threes with extra chars before & after the number
  • Group Separator Character: “,”
  • Decimal Point Character: “.”

Formatting Examples

The unique number column type can be formatted in the same manner as the number column. This is very powerful. For instance, if you wanted to have an automatic purchase order number you could format the unique number column to display as “Purchase Order 4233.”

Learn more about date formatting.