Convert decimal to text

abab Member Posts: 37
Hallo,

With the format-function you can convert decimal to text. How can you force it that there will be always 2 decimals ?

decimal variable = 2
text variable = '2.00'

decimal variable = 3.5
text variable = 3.50

Thanks

Comments

  • KowaKowa Member Posts: 923
    Like this :
    FORMAT(MyAmount,0,<Precision,2:2><Standard Format,0>);
    
    Kai Kowalewski
  • abab Member Posts: 37
    Works fine !

    Thanks
Sign In or Register to comment.