Currency

  • Updated

The Currency data type mceclip0.png is for inputting currency values with a specific currency symbol. Currency data types have the same formatting options as Number data type but allow you to add and format currency symbols.

mceclip1.png

Currency data types are great for accounting, budgeting, and more. Also, you can add formulas in  Currency cells to compute currency data. For other uses, Spreadsheet.com has custom data types for numbers, dates, or formulas you want to apply column-wide, check out our articles on those topics if your data matches those uses.

Strict

Like other data types, Currency data types can have Strict enabled. Selecting the Strict checkbox for Currency cells will restrict users to input only numeric characters. Also, columns that have Strict enabled cannot have cells of different data types.

Note: Currently, formulas are not allowed in Strict Currency 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 Currency 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 currency data like this: mceclip0.png.

Negative numbers

In Spreadsheet.com, you can choose from three default formats for negative currency. Including, the negative sign, parenthesis, or representing negatives in red. 

mceclip1.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

Currency symbol

Also, you can adjust the formatting for different currency symbols for different countries. Spreadsheet.com currently supports over 30 countries if you would like us to add another, feel free to reach out at info@spreadsheet.com.

mceclip3.png
  

In addition to the Currency data type, Spreadsheet.com has unique data types for dates, duration, column-wide formulas, and more. Check out our many other custom data types.