How to format a number field

Modified on: Mon, 24 Feb, 2020 at 5:35 PM


Applicable plans
Sprout Blossom Garden EstateForest


Quick Steps:

Admin settings > CRM CUSTOMIZATION > Leads/Contacts/Accounts/Deals > ADD FIELD > Select number field> Type in the field label > Under Number format > Choose desired format > Hit


Why is number formatting required?

Representation of currency or volume (number of units sold) can be formatted, which enhances readability and comes in handy if you have customers across locations.


How does Freshsales support the formatting of numbers?

Freshsales supports multiple number formats followed in major parts of the world. Periods and commas can be used to separate decimal points. All custom fields of the type ‘number’ can be formatted.


The following formats are supported


Format

Description

9,999,999,999.99

Used in North America, the UK, Southeast Asia, China, Japan and  Australia.

9.999.999.999,99

Used in South America and some European countries

9,99,99,99,999.99

Used in India and Bangladesh

9 999 999 999,99

Used in most European countries


How to format a number field? 

  1. Go to Admin settingsCRM CUSTOMIZATION > Leads/Contacts/Accounts/Deals Module

  2. Click . In the  ADD FIELD overlay that opens up, choose Number and click

In the ADD FIELD overlay that appears, type the name of the desired custom field

  1. Type in the desired Field label

  2. Retain the value as Number under Field type

  3. Under Number format you can choose from four different types of number formats:

Where does the number format reflect in Freshsales?

  1. Record detail page

  2. List pages

  3. In the forms, while adding/editing records

  4. Emails (using placeholders) and email templates

  5. Built-in reports

Note:

  • The input values can have 11 digits before the decimal mark and 4 digits after

  • Formatting is not supported in filters and in web forms



Did you find it helpful? Yes No

Can you please tell us how we can improve this article?

Sign up for Freshsales today

Start your 21-day free trial. No credit card required. No strings attached.

Start Free Trial

How to format a number field

Modified on: Mon, 24 Feb, 2020 at 5:35 PM


Applicable plans
Sprout Blossom Garden EstateForest


Quick Steps:

Admin settings > CRM CUSTOMIZATION > Leads/Contacts/Accounts/Deals > ADD FIELD > Select number field> Type in the field label > Under Number format > Choose desired format > Hit


Why is number formatting required?

Representation of currency or volume (number of units sold) can be formatted, which enhances readability and comes in handy if you have customers across locations.


How does Freshsales support the formatting of numbers?

Freshsales supports multiple number formats followed in major parts of the world. Periods and commas can be used to separate decimal points. All custom fields of the type ‘number’ can be formatted.


The following formats are supported


Format

Description

9,999,999,999.99

Used in North America, the UK, Southeast Asia, China, Japan and  Australia.

9.999.999.999,99

Used in South America and some European countries

9,99,99,99,999.99

Used in India and Bangladesh

9 999 999 999,99

Used in most European countries


How to format a number field? 

  1. Go to Admin settingsCRM CUSTOMIZATION > Leads/Contacts/Accounts/Deals Module

  2. Click . In the  ADD FIELD overlay that opens up, choose Number and click

In the ADD FIELD overlay that appears, type the name of the desired custom field

  1. Type in the desired Field label

  2. Retain the value as Number under Field type

  3. Under Number format you can choose from four different types of number formats:

Where does the number format reflect in Freshsales?

  1. Record detail page

  2. List pages

  3. In the forms, while adding/editing records

  4. Emails (using placeholders) and email templates

  5. Built-in reports

Note:

  • The input values can have 11 digits before the decimal mark and 4 digits after

  • Formatting is not supported in filters and in web forms



Did you find it helpful? Yes No

Can you please tell us how we can improve this article?

Sign up for Freshsales today

Start your 21-day free trial. No credit card required. No strings attached.

Start Free Trial