Text formatting of formula columns for Currency

I am trying to format a formula column as follows
TEXT({Amount}+({Amount}*({VAT Rate})),“£#,###.##”)
The displayed output is as the number format states but does not display the £ sign.

I also want to format a number column to have two decimal points but cant find out how to do this.

this post has a work around that works for me

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.