function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SFDCRKSFDCRK 

Comma in number field??

Hi All,
Is it possible to remove the command from the number field? i.e. if the data type is number field, and the value is greater than thousand, then SFDC automatically starts to add comma e.g. 1,096 is it possble to not show the comma OR write a formula so that it would remove the comma? oh I do NOT want to create a text field to overcome this difficulty. Any help would be really great.

Thanks,
RK
devNut!devNut!
You could create a formula field, but you'll end up with 2 fields. i.e. one that displays and one that you use perhaps for integration.

The other option like you said, is to use a text field which will apply no formatting.
SFDCRKSFDCRK
thanks for your response devnut!
msilbermsilber
My advice is to only use number fields where you will be doing calculations / math, otherwise store a number as text. You can use the ISNUMBER validation rule function to ensure the field only contains numbers if you go the text field route.