Cijo- Decimal

Results 1 to 3 of 3

Thread: Cijo- Decimal

  1. #1
    Cijo Guest

    Default Cijo- Decimal

    How can I display two zeroes after the decimal point from the database? Say for e.g. 2.00.I used the round() funtion. But still it is displaying 2 and not 2.00

  2. #2
    Join Date
    Dec 1969

    Default RE: Cijo- Decimal

    varNum contains your number, for the sake of argument<BR><BR><BR>varNum & ".00"<BR><BR><BR>&#060;rocket science&#062;<BR><BR>j

  3. #3
    David Forster Guest

    Default RE: Cijo- Decimal

    That&#039s fine if you know that eveything returned from the DB is going to be an Integer. But what if this is not the case?<BR><BR>If you are using this for monetary values then what about using the FormatCurrency function?<BR><BR>Or, how about using the FormatNumber function?<BR><BR>Syntax would be:<BR><BR> FormatNumber(&#060;&#060;your expression&#062;&#062; ,2 ,-1 ,0 ,0)<BR><BR>David.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts