Hi,

I am trying to set my number/formula column to always show 2 decimal places. I have applied previous suggestions from this forum as follows: **“£”&SUM({Actual Deal Value}*0.35,“#,#0.00”)**, as well as a ROUND suggestion, however they do not appear to work.

Any help much appreciated!

Hi@AndrewSpeer ,

we have gone through your formula,we tried TEXT function instead of ROUND.

here is the formula we have gone through and got the correct answer:

TEXT({Actual Deal Value}*0.35,“$#,##0.00”).

Hope its helpful to you.

For further implementation details kindly connect us:

MSquare Support

Visit us here

Youtube Channel

Thankyou @MsquareAutomation , I tried your suggestion, however I am getting an error. Do you mind double checking I have this correct? I also changed the ‘$’ to ‘£’ which I will need. Both give the error.

Thanks in advance

Hi@AndrewSpeer,

we have tried this again.please go through this formula.

“£”&TEXT({Actual Deal Value}*0.35,“##0.00”)

For further implementation details kindly connect us:

MSquare Support

Visit us here

Youtube Channel

No need to do anything actually. Unless i am missing something on what you are trying to achieve you could simply use {Actual Deal Value}*0.35

Andif you add sum in the bottom of the columns you can set the £ there and it shows for every row. No need to add it manually with formulas and you can totally actualy use the numbers as currency

Currently unfortunately although obvious currency doesn’t show 2 decimals if the last ones are zeros which very frustrating. There is another formula that overcomplicates things for that. Here it uses the formula to also subtitute . and , for us Europeans but should be the same principle. I would keep it simple though only by using the formula and adding the sum.

Thank you @MsquareAutomation and @taspan ,

both your solutions worked.

In terms of always showing 2 decimal places, this should be something that Monday.com should fix asap, as this will always mean manual editing in DocuGen.

And it is so easy to implement. Simply when the number is set to currency it is obvious it should store the value and show with two decimals and the same thing could apply to formulas just the same way it adds the currency symbols. Though this is treated as “NEW feature” and not basic functionality. It really amazes me

Personnaly i use a formula as a workaround, that is working in DocuGen.

If i have in my column Total TTC* : 1234

i will have for exemple in my new formula column 1.234,00 €

and i can use this new column in DocuGen.

Formula:

if({Total TTC*}>=1000,rounddown({Total TTC*}/1000,0) & “.” & right(“000” & rounddown({Total TTC*} - 1000*rounddown({Total TTC*}/1000,0),0), 3), “”) & if({Total TTC*}<1000, rounddown({Total TTC*} - 1000*rounddown({Total TTC*}/1000,0),0) ,“”) & “,” & right(“00” & (({Total TTC*}*100) - rounddown({Total TTC*},0)*100),2) & " €"

Hi, I’m writing to share a strange behavior of the Monday.com board regarding decimal numbers.

- In the AMOUNT column there is a series of numbers starting from 0 with steps of 1/100 (European format, comma is decimal divisor);
- in the FORMULAtoEU column I have inserted your formula to format the decimal numbers in European format.
- In the FORMULA2 column I multiplied AMOUNT by 100, and I obtained correct values;

Now, in the FORMULA3 column I inserted an empty text ( " " ) before the multiplication itself, and now I get some anomalous values (see ERROR item) which distort the results of some FORMULAtoEU values.

Has anyone else observed this?

Hi, maybe I found an alternative solution, waiting to understand why.

by adding a ROUND() immediately after the final RIGHT() function, I eliminate the many decimal places that appeared in the column, like this updated formula:

if({Amount}>=1000,rounddown({Amount}/1000,0) & “.” & right(“000” & rounddown({Amount} - 1000*rounddown({Amount}/1000,0),0), 3), “”) & if({Amount}<1000, rounddown({Amount} - 1000 *rounddown({Amount}/1000,0),0) ,“”) & “,” & right(“00” & ( Round({Amount}*100,0) - rounddown({Amount},0)* 100),2).

If anyone wanted to try it, they could confirm if it is OK

You were right, there was an issue in my formula; But yours was generting an error on my side. It seems that this one is working, let me know if you disagree (i have added two times a “*”):

IF({Amount}>=1000, ROUNDDOWN({Amount}/1000,0) & “” & RIGHT(“000” & ROUNDDOWN({Amount} - 1000 *ROUNDDOWN({Amount}/1000,0),0), 3), “”) &

IF({Amount}<1000, ROUNDDOWN({Amount} - 1000 *ROUNDDOWN({Amount}/1000,0),0) ,“”) & “,” & RIGHT(“00” & (ROUND({Amount}*100,0) - ROUNDDOWN({Amount},0)*100),2)

or if you want to have a format ##.###,##:

IF({Amount}>=1000, ROUNDDOWN({Amount}/1000,0) & “.” & RIGHT(“000” & ROUNDDOWN({Amount} - 1000 *ROUNDDOWN({Amount}/1000,0),0), 3), “”) &

IF({Amount}<1000, ROUNDDOWN({Amount} - 1000 *ROUNDDOWN({Amount}/1000,0),0) ,“”) & “,” & RIGHT(“00” & (ROUND({Amount}*100,0) - ROUNDDOWN({Amount},0)*100),2)

let me know if you disagree. Thanks a lot for your help

Hi, Joachim, thanks for your reply.

I’ve tried again your formula and it give me an error !

It is Incredible, both seems identical …I’m was very confused…

So, tried to analyze it, copying both text in a Word file, I check that differs only by one thing, I found two different kind of “”.

When substituted the “” in your formula with “” from my keyboard , your formula are fully functional.

May this help anyone could have same not obvius issue.

Thanks , again, for your work.

When you are sharing code, formula’s etc on this platform it is best to use preformatted text, like this

```
preformatted "text"
```

because normal “text” might be converted to smart quotes. For the fun try to copy both double quoted text above and paste it in an editor. Notice the difference between straight quotes and smart quotes.