+ Start a Discussion
vishal yadav 62vishal yadav 62 

year is coming like this type 2,009 i don't want comma

Hi folk,

year is coming like this type 2,009.   i don't want comma .in data base int(10) . which was in php .so i created field year__c and taken data type -number. 
if i'm taken data type text then (comma) is not coming . but i need year data type number without comma 
Result ---2009

pls help me out 
 
Wilfredo Morillo 20Wilfredo Morillo 20
In the detail page you will see a coma but not in the backend. For example if you query for your year__c the return will be 2009. The field in the details page adds the coma as a  formatted field. 

 
Suraj TripathiSuraj Tripathi

Hi Vishal,

Create a new custom field, where type is "formula" and the formula return type is "text".

In the formula, use the TEXT() function, and pass the existing number field value into this formula. For example, if your number field is MyNumber_c then your formula would be: TEXT( MyNumber_c )

Your users will enter values into the existing number field, but you can use the formula field (which doesn't display thousands separators)

And don't forget to mark this answer as best, if answer this helps you :-)

Regards,

Suraj