• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

number accurency

hi, how can i limit number accurency , for example i have floating point number  (LETS SAY dOUBLE TYPE)
and i want that the numbers will be just 3digit after the floating point
so number like this  2.234789753453e-16 will be consider as zero .
and from the oposite number like 4.456 will stay in his Current Value


0
asi
Asked:
asi
1 Solution
 
zacCommented:
The easiest and most simple way is to use a mask edit if it is non DB data or to set the Displayformat and EditFormat of the field if it is a DB item.

The format you'll probably want is something like:

#.000

I hope this helps.

cheers,

Zac
0
 
ronit051397Commented:
showmessage(FormatFloat('#,##0.###', 2.234789753453e-16));
0
 
asiAuthor Commented:
as always ... Ronit
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now