How to make a formula column money value with currency sign and two decimal places after?

Platform discussions
1

I have a formula column which is multiplying two columns:

{Quantity}*{Unit Price}

How do I make the column show as £#.## rather than ### so that when I generate a docugen document, it automatically makes it a monetary value so I don’t have to edit it manually?

2

This formula should do it:
CONCATENATE(“£”,TEXT({Quantity}*{Unit Price},“£#,###.00”))
Just be careful if you need to use the value in a later formula, as it will be formatted as text rather than as a numerical value. :slight_smile:

3

Thank you. I will need to use the value in a further column unfortunately.

4

In that case you can either create a hidden column with the formula

{Quantity}*{Unit Price}

which you can use again later and then reference the formatted version in your docugen template, or insert the above formula directly into you later formula.