Data formatting options
Numeric, text, date, and datetime fields support a number of different formatting options that are useful in different situations.
Numeric data formats
Supported formats
Numeric fields support the following formatting options:
- number
- currency
- financial
- percent
Rounding options
Any format can be displayed as the exact number, rounded to the nearest whole number, or rounded to two decimal places.
Note
Rounding is to the nearest decimal.
Note
The rounding settings you choose here are used in visualizations based on this data.
Text data formats
Text data fields support plain text or a subset of HTML elements.
Supported HTML elements
- bold <b>
- italic <i>
- underline <u>
- ordered list <ol>
- unordered list <ul>
- anchor <a>
- image <img>
Image tag src attributes may reference images hosted on external domains.
Note
If you click an HTML link in the table, the page opens within the Table View. Use the browser back button to navigate back to the table.
When to use HTML formatting
HTML formatting is useful for:
- free form text questionnaire responses that include HTML formatting
- .csv files that include HTML formatting in specific fields
- records imported from Analytics, Analytics Exchange, or Add-In for Excel that include HTML formatting
Date and datetime data formats
Date and datetime fields support a number of common date formats that are used in different locales and by different systems.
