function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jason McCarthy 2Jason 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.
Abhishek BansalAbhishek Bansal
Hi Jason,

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.