---
title: "Change number and date format"
slug: "change-number-format"
description: "Set numeric field values to match the format typically preferred in your locale."
updated: 2022-11-02T22:49:38Z
published: 2022-11-02T22:49:38Z
canonical: "docs.zilliant.com/change-number-format"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Format numbers

You can set numeric field values to match the format typically preferred in your locale.

Your locale settings determine the format of numbers. Your locale settings do not affect other users; they are unique for each user.

          Note

          

Locale preferences are set in your Salesforce org.

1. Select your profile from the top right of the app window.
2. Select **Settings**.
3. In the left panel of the **Personal Information** page, select **Language & Time Zone**.
4. Select a locale from the list of options, then select **Save**.

If the new locale setting supports a different convention than the previous setting, the format of numbers that appear in the app changes automatically.

#### Example

If your locale setting is **English (United States)**, numbers appear as:

1,199.19

If you change to the **French** locale setting, the same number appears in the app as:

1199,19

#### Limitations

When performing formulaic bulk updates, defining calculated columns, or defining KPI cards, you must use a . (period) as the decimal separator, regardless of the decimal separator for your preferred locale settings. However, you can use your regional decimal separator when entering or pasting numbers directly into worksheet cells.