When you are using the Table Structure Panel to format the layout of your Table Document, you have the option of choosing what type of content will go into each of your columns. A “number column” is a type of column that you can choose in the Table Structure Panel. By choosing “number” as your type of column, you are choosing what type of information that particular column will have in your final 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.

Choosing number as column type

When you are adding a column to your Table Document, you can choose “number” as the column type and then select your preferred number formatting from a drop-down menu.

Formatting

You can choose the following formatting options in the number column:

  • US Standard - This is the standard American format (0,000.00) for presenting numbers. If you type in a number as 1234, this formatting will automatically add a comma to make the number 1,234.
  • US Integer - This format will round any numbers you have to the nearest whole number. For example, if you type in a number as 123.5, in this format the number will get rounded up to 124. This allows you to keep the original decimal number but have the appearance of a whole number.
  • US Currency - This format will insert dollar signs at the front of your number and round any decimals up to the two nearest decimal points. For example, if you type in the number as 1234.567, the number will show as $1,234.57.
  • European Dot Separator - This format uses the European format of using a period to separate between hundreds of numbers. For example, if you enter a number as 1234, it will show as 1.234.
  • European Space Separator - This format uses a space to separate between hundreds of numbers. For example, if you enter a number as 1234, it will show as 1 234.

See the chart below for how numbers are formatted by default using “number” as the column type in a Table Document. The number “1234.567” was entered into all of the cells so that you can see how each number format treats the same number.

Note: By default the number column only keeps numbers up to two decimal points over. For example, if you type in a number as 1234.567, the number will get rounded up to 1234.57. You will need to change the number formatting to have your numbers show more that two decimal points. Learn more about number formatting.

To edit the number format in your numbers column in the Table Structure Panel, learn more about the Extra Type Info column.