Spreadsheet User Guide
  • Introduction
  • Hot Keys List
  • Work with Cells
  • Work with Rows and Columns
  • Data Formatting
  • Number Formatting
  • Excel Import/Export
Powered by GitBook
On this page
  • Supported number formats
  • How to set format

Was this helpful?

Number Formatting

PreviousData FormattingNextExcel Import/Export

Last updated 6 years ago

Was this helpful?

Supported number formats

There are 4 number formats your can apply to format numeric values of cells:

  1. Common - numbers are displayed as is, with no formatting applied (1415045928)

  2. Number - numbers are displayed with tens, hundreds and thousands separated by specified delimiters (1,415,045,928.00)

  3. Currency - together with the Number format numbers get the currency sign ($1,415,045,928.00)

  4. Percent - together with the Number format numbers get the percent sign (141,504,592,800.00%)

How to set format

Follow the steps below to apply a particular number format to SpreadSheet data via the toolbar:

  • Select a cell or several cells that you want to format.

  • Click the Number format button:

  • Select the format you want to apply among the suggested options:

Using various number formats for values of cells
Number format button
Options of the Number format button