Text formatting of formula columns for Currency

Feature requests
1

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.

2

this post has a work around that works for me

3

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