/
Number + Currency Formatting

Number + Currency Formatting

This article describes how to set Number and Currency Formatting when you use Number column.

Select Enable Number Formatting to set format.

image-20241121-104246.png

Currency Formatting

Set currency format with over 160 currencies.

  1. Select Custom Currencies Format

image-20241121-112834.png
  1. Select a currency and click Apply.

image-20241121-112937.png
  1. Click Add button to add column.

image-20241121-110406.png
  1. Add row and type the number to the number field. Click out of the field or press Enter on your keyboard.

image-20241121-110644.png
  1. Result: The typing number has currency format.

image-20241121-110823.png

Number Formatting

  1. Select Custom Number Format

image-20241121-111107.png
  1. Select or custom a number format or and click Apply.

image-20241121-111245.png

You can custom the number format by using common syntax characters.

Custom Number Format: Here is a list of common syntax characters that can be used to create a custom number format:

Format

Definition

Format

Definition

0

A digit in the number. An insignificant 0 will appear in the results.

#

A digit in the number. An insignificant 0 will not appear in the results.

.(period)

Formats numbers with a decimal separator.

,(comma)

Formats numbers with a thousands separator.

"text"

Adds text to the formula. Insert the desired text within quotations for it to appear.

%

Formats numbers as a percent

E

Formats numbers as an exponent.

;

Separates positive and negative sub patterns

@

1@ = 1 input

  1. Click Add button to add column.

image-20241121-111351.png
  1. Add row and type the number to the number field. Click out of the field or press Enter on your keyboard.

image-20241121-111637.png
  1. Result: The typing number has corresponding format (percent format in this case).

image-20241121-111714.png