Format String


I want to format a decimal into a string field, but ensure I always take a minimum of two decimal places and lose the thousand seperators.

The code I’m using is.

LtxtString := FORMAT(ROUND(VrecGJL.Amount,0.01),0,2);

But I lose the decimal places?

Does anybody know how to do this quickly without having to write a function for this.


This helped me…

ValueAsText := FORMAT(YourDecimalValue,0,’<Precision,2:2><Standard Format,0>’);

Many Thanks, worked a treat