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.
ShowAll Questionssorted byDate Posted
Rick SF Admin

# Adding text to the end of the value of a formula (text) field

I have a custom formula text field using the formula shown below. The output from this formula gives me what I need for the most part, except now I'm trying to add the letter "M" to the end of the value in that field (i.e. \$23.5M). I've tried adding the "M" to the forumla following other documentation but no luck. What am I missing?
```CASE(LEN(TEXT( Revenue__c )),
1, TEXT(Revenue__c),
11, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)),
10, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)),

TEXT(LEN(TEXT( Revenue__c )))
)```
Best Answer chosen by Rick SF Admin
Steven Nsubuga
```CASE(LEN(TEXT( Revenue__c )),
1, TEXT(Revenue__c) + 'M',
11, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',
10, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',

TEXT(LEN(TEXT( Revenue__c ))) + 'M'
)```

### All Answers

Steven Nsubuga
```CASE(LEN(TEXT( Revenue__c )),
1, TEXT(Revenue__c) + 'M',
11, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',
10, '\$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',

TEXT(LEN(TEXT( Revenue__c ))) + 'M'
)```

This was selected as the best answer
Rick SF Admin
Thank you.