---
schema_version: "1"
id: e9b90cd5a5fccfd778fcae766b50eb6b23b2a2bba9ee51318aab703815abbe21
title: Format Numbers
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_format_numbers.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_format_numbers.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 10963a2120dda4c824ec77383f8c1d6b80cc55d6a55be9441655f6aff32fefc7
description: Choose either preset or custom number formats. Specify custom formats for positive, negative, and zero values.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Format Numbers

Choose either preset or custom number formats. Specify custom formats for positive, negative, and zero values.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
          <colgroup>
            <col style="width:50%">
            <col style="width:50%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d179604e72">User Permissions
                Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d179604e72 ">To view visualizations:</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d179604e72 ">Use CRM Analytics</td>

            </tr>
          </tbody>
        </table>

1. Click ![Button dropdown for formatting from left panel](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_format_number_button.png) on any measure field.
2. Choose **Format Numbers** and choose a preset format.
    
    ![fullscreen showing menu for custom number format](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_number_formats_fullscreen.png)
    
    1. Click **Custom…** for more presets or to specify your own custom format.
        
        ![custom number format modal](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_custom_number_modal.png)
    2. Use a preset or enter a custom string in the **Format** string.
    
    For multiple formats, use this syntax: <POSITIVE\_FORMAT>;<NEGATIVE\_FORMAT>;<ZERO\_FORMAT>.
    
    The **Format** string always uses a comma (,) for the thousands separator and a period (.) for the decimal separator. Change the separator in the **Thousands** or **Decimal** string to override the separator in the **Format** string. CSV downloads ignore the specified separators and always use the default values of comma (,) for thousands and period (.) for decimal.
3. Click **Done** to save the format.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    Note In the Spring ’20 release we unified number behavior in charts, tables, and number widgets.
    
    - 0 values follow formula logic. For example, a format string $#.## with a 0 value returns $0.00.
    - Default behavior never returns a negative 0.
    - Short numbers like 1.0x always return 1.0x, not 1x.
    - Negative and zero formats are optional.