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.

[image] Adding Dollar Sign to formula column Special workflows & use cases I created a formula column and I want to display the dollar sign in the column. I used the text option for the dollar sign but when I did that, only one of my formula columns worked and the other o…

Text formatting of formula columns for Currency

Feature requests

D.Stockford (David Stockford) October 5, 2022, 2:45pm 2

this post has a work around that works for me

Topic		Replies	Views
Adding Dollar Sign to formula column Special workflows & use cases formula	19	16391	November 4, 2023
Formula column, applying 2 decimal point rule within formula/number column Platform discussions formula	12	2624	September 16, 2023
How to put £ sign before converted currency formula? Special workflows & use cases formula	3	1320	July 1, 2022
Currency missing from formula column Platform discussions columns , formula	1	2327	February 18, 2022
Format Formula into money Special workflows & use cases formula	1	2516	April 9, 2022

Text formatting of formula columns for Currency

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Text formatting of formula columns for Currency

Related Topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?