Percent

  • Updated

 

The Percent data type mceclip1.png is like the Number data type, but for percentages of numbers. Currency data types have custom formatting options and accept numeric characters, but are shown with the % symbol and calculated as percentages in formula.

mceclip0.png

Like other number types, you can convert existing data (for instance fractions and decimals) to the Percent data type (for instance 0.5 to 50%). Setting your cells and columns as the percent data type is helpful for differentiating those numbers you think of in terms of percentage, like interest rates, discounts, or how complete this sentence is (100%).

Strict

Like other data types, Percent data types can have Strict enabled. Selecting the Strict checkbox for Percent cells will restrict users to input only numeric characters. Percent data types will convert any numerical entry to a percentage, for instance, typing "5" results in mceclip3.png and typing "0.5" results in mceclip2.png. Also, columns that have Strict enabled cannot have cells of different data types.

Note: Currently, formulas are not allowed in Strict Percent cells. When there are existing formulas in a column, cell, or range of cells and you change to strict, those formulas will be converted to the output value. You can always revert by selecting undo in the toolbar mceclip0.png or with the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).

Decimal places

With the Percent data type, you can select how many decimal places to show. Like other spreadsheets, Spreadsheet.com defaults to 2 and does not delete any numerals not shown, simply hides them. Defaulting to percent data like this: mceclip4.png

Format Drop-down

The Format drop-down at the bottom of the update dialog window allows you to customize which characters you use for formatting, for instance choosing a comma or period as the 1000 separator. This is helpful to format for different countries or style preferences. 

mceclip2.png

In addition to the Percent data type, Spreadsheet.com has unique data types for CurrencyDates, Duration, Column-wide formulas, and more. Check out our many other custom data types.