decimal Format

Business Central/NAV Developers Forum
1

With this Sintaxe

FORMAT(PADSTR(’’,10- STRLEN(XX),‘0’) + XX)

my number cames like: 0000000012

How can I change the same sintaxe for the output to be like:

00000012.00

Thanks

2

try

Dec := 12;
Message(’%1’,PADSTR(’’,10- STRLEN(Format(Dec)),‘0’)+FORMAT(Dec,0,’<Precision,2:2><Standard Format,0>’));

where dec is a variable of decimal datatype…

3

Mohana

With your idear the resulst is 0000000012, and I need 00000012.00 :slight_smile:

thanks

4

If you run above code, the result is

Microsoft Dynamics NAV Classic

0000000012.00

OK

Make sure Dec variable is of datatype Decimal…