You need to sign in to do that
Don't have an account?
Jason McCarthy 2
Limit a Text formula to 7 characters
How can I limit a text formula field to 7 characters because I am doing an amount calculation in this, I had various data types and Text formula was the only one that it came out correctly in. Now I am having an issue where the field is producing 36 decimal places.
You can use MID function in formula field which will return the specific string.
Syntax : MID(text, start_num, num_chars)
In your case Mid(YourTextValue,0,7)
Let me know if you need more help on this.
Thanks,
Abhishek