# Format String

**URL:** <https://www.dynamicsuser.net/t/format-string/9789>\
**Category:** Developers Forum\
**Created:** [March 16, 2005, 3:19pm UTC](https://www.dynamicsuser.net/t/format-string/9789 "2005-03-16T15:19:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandy](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sandy](https://www.dynamicsuser.net/u/Sandy)\
**Post date:** [March 16, 2005, 3:19pm UTC](https://www.dynamicsuser.net/t/format-string/9789/1 "2005-03-16T15:19:06Z")

</div>

I know there are lots of different options using the Format String, but I can’t get it to work properly in the instance that I am using. I am trying to display a dollar figure with 2 decimal points on a report, which in itself isn’t that difficult, BUT I am including it in a Text String. Here’s what I have. SourceExpr = ‘Average Price of $’ + format(AveragePrice) I need AveragePrice to be x.xx. I’ve tried to use string but I get an error Type conversion is not possible blah blah… I know this is probably a no brainer, but I’m having a brain block today. Thanks.

---

<div class="post-metadata">

**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\
**Post date:** [March 16, 2005, 3:30pm UTC](https://www.dynamicsuser.net/t/format-string/9789/2 "2005-03-16T15:30:32Z")

</div>

Maybe you can try this: FORMAT(AveragePrice,0,’\<Precision,2:2\>\<Standard Format,0\>’)

---

<div class="post-metadata">

**Author:** ![Sandy](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sandy](https://www.dynamicsuser.net/u/Sandy)\
**Post date:** [March 16, 2005, 4:50pm UTC](https://www.dynamicsuser.net/t/format-string/9789/3 "2005-03-16T16:50:10Z")

</div>

Work like a charm…thanks.