You need to sign in to do that
Don't have an account?
vishal 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
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
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