Always display two digits after decimal separator navision

bpavlov

I'm using Microsoft Navision 2009. I'm creating report that includes several number with decimal separator (double/float number in C#).

I'm stuck at the point where I want to display every number with two digits after decimal point.

Ex:

if number is 100, I want to display 100.00 if number is 100.5, I want to display 100.50 if number is 100.55, I want to display 100.55 if number is 100.505; i want to display either 100.51 or 100.50

Thank you in advance;

Language that I'm using is C/AL

Mak Sim

Don't be lazy. Read essential manuals. Format function is your best friend in Nav.

strsubstno(text01,format(100.10,0,'<Precision,2:2><Standard Format,0>')) Third argument of Format is actually the format of result text. <Precision,2:3> means that if first argument is decimal it will have from 2 to 3 (minimum 2 and maximum 3) digits in decimal part. <Standard Format,0> means that the rest of format will be standard.

More here!

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Always display at least two decimal places

From Dev

Save list to csv with two decimal digits in python?

From Dev

How to display two digits after decimal point in SQL Server

From Dev

How to format longs in android to always display two digits

From Dev

Printing two digits after decimal in go

From Dev

Format a number to always have a sign and decimal separator

From Dev

PostgreSQL : How to select values with only two digits after decimal point in a table?

From Dev

How can I round a float such that there are only two trailing digits after the decimal point?

From Dev

How to convert a string of numbers in a number with the last two digits always decimal (though 00)

From Dev

How to format numbers in javascript to two decimal digits?

From Dev

How do I use string formatter to restrain two digits before decimal point and two digits after in Ruby?

From Dev

Decimal not showing group(thousand) separator after parse

From Dev

How to remove two digits after decimal in SQL Server

From Dev

Android - LocationManager digits after decimal

From Dev

How to display three digits before the decimal point?

From Dev

How to get upto two digits after decimal in PHP

From Dev

How to get numbers to always display as two digits

From Dev

Show the float value in formatted string two digits after decimal in iPhone

From Dev

Java Double to String with dot separator and infinite number of digits after the decimal

From Dev

Extracting digits after decimal MATLAB

From Dev

PostgreSQL : How to select values with only two digits after decimal point in a table?

From Dev

How to print only two digits after decimal with System.printf?

From Dev

Remove digits after decimal in Javascript

From Dev

Treat Comma and Period as Decimal Separator in Navision Decimal Fields

From Dev

Decimal Regex Constraint Matching (Four digits before optional decimal point and two after)

From Dev

How do I use string formatter to restrain two digits before decimal point and two digits after in Ruby?

From Dev

Two digits after comma

From Dev

Max +1 with two digits always

From Dev

Displaying two digits after decimal point mysql table

Related Related

  1. 1

    Always display at least two decimal places

  2. 2

    Save list to csv with two decimal digits in python?

  3. 3

    How to display two digits after decimal point in SQL Server

  4. 4

    How to format longs in android to always display two digits

  5. 5

    Printing two digits after decimal in go

  6. 6

    Format a number to always have a sign and decimal separator

  7. 7

    PostgreSQL : How to select values with only two digits after decimal point in a table?

  8. 8

    How can I round a float such that there are only two trailing digits after the decimal point?

  9. 9

    How to convert a string of numbers in a number with the last two digits always decimal (though 00)

  10. 10

    How to format numbers in javascript to two decimal digits?

  11. 11

    How do I use string formatter to restrain two digits before decimal point and two digits after in Ruby?

  12. 12

    Decimal not showing group(thousand) separator after parse

  13. 13

    How to remove two digits after decimal in SQL Server

  14. 14

    Android - LocationManager digits after decimal

  15. 15

    How to display three digits before the decimal point?

  16. 16

    How to get upto two digits after decimal in PHP

  17. 17

    How to get numbers to always display as two digits

  18. 18

    Show the float value in formatted string two digits after decimal in iPhone

  19. 19

    Java Double to String with dot separator and infinite number of digits after the decimal

  20. 20

    Extracting digits after decimal MATLAB

  21. 21

    PostgreSQL : How to select values with only two digits after decimal point in a table?

  22. 22

    How to print only two digits after decimal with System.printf?

  23. 23

    Remove digits after decimal in Javascript

  24. 24

    Treat Comma and Period as Decimal Separator in Navision Decimal Fields

  25. 25

    Decimal Regex Constraint Matching (Four digits before optional decimal point and two after)

  26. 26

    How do I use string formatter to restrain two digits before decimal point and two digits after in Ruby?

  27. 27

    Two digits after comma

  28. 28

    Max +1 with two digits always

  29. 29

    Displaying two digits after decimal point mysql table

HotTag

Archive