Format String

Business Central/NAV Developers Forum
1

Guys,

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.

Regards

2

This helped me…

http://www.mibuso.com/forum/viewtopic.php?t=17886&highlight=decimal+format

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

3

Many Thanks, worked a treat