Format currency in column heading

[fangfacekitty]

Hello,

In my table I want one of the columns to be titled "Paid" with the sum included. I have this formula, it works fine. When the data changes so does the sum :
="Paid "&SUM(D2:D999)

My problem is that it returns a result like this "Paid 377347.65482348".

The amount is correct but what I really need to show is "Paid €377347", with no decimals and the currency symbol. All the values in the column are the same currency, so I do not need to worrk about conversions or if/thens (I hope).

How can I get the amount in the column header formatted in € ?

Thanks in advance for your help !

 

[Comfy]

="Paid "&TEXT(SUM(D2:D999),"€0")


Note:
You cannot use formulas in ListObjects (Excel Tables)

 

[gaz_chops]

Try

="Paid "&TEXT(SUM(D2:D999),"€#")

 

[JackDanIce]

Try:

="Paid "&TEXT(SUM(D2:D999),"€#")

 

[fangfacekitty]

Great, both options work. Thanks !

 

[gaz_chops]

You're welcome.