# Formatting Decimals When Exporting as Text

**URL:** <https://www.dynamicsuser.net/t/formatting-decimals-when-exporting-as-text/9643>\
**Category:** Developers Forum\
**Created:** [February 3, 2005, 11:17am UTC](https://www.dynamicsuser.net/t/formatting-decimals-when-exporting-as-text/9643 "2005-02-03T11:17:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt.Hill](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@Matt.Hill](https://www.dynamicsuser.net/u/Matt.Hill)\
**Post date:** [February 3, 2005, 11:17am UTC](https://www.dynamicsuser.net/t/formatting-decimals-when-exporting-as-text/9643/1 "2005-02-03T11:17:41Z")

</div>

I’m exporting a report as a plain text file, however, any decimal values that are generated appear as ‘123.4’ (for 123.40) or 500 (for 500.00). Is it possible to have the correct number of decimals added as part of the FORMAT command being used to generate them? Thanks

---

<div class="post-metadata">

**Author:** ![zimiwings](https://avatars.discourse-cdn.com/v4/letter/z/dec6dc/32.png) [@zimiwings](https://www.dynamicsuser.net/u/zimiwings)\
**Post date:** [February 3, 2005, 12:15pm UTC](https://www.dynamicsuser.net/t/formatting-decimals-when-exporting-as-text/9643/2 "2005-02-03T12:15:32Z")

</div>

Hi Mathew, here’s an example of how to build your Format: FORMAT(Item.“Unit Price”,0,’\<Precision,2:2\>’); For more information on how to use FORMAT refer to the C/Side Reference Guide. regards Daniel Zimmermann