Results 1 to 3 of 3

Thread: [RESOLVED] How to ROUND-OFF Value

  1. Apr 19th, 2007, 04:05 AM #1
    nancy_padillon
    nancy_padillon is offline

    Thread Starter
    Lively Member nancy_padillon's Avatar
    Join Date
    Mar 2007
    Posts
    70

    Resolved [RESOLVED] How to ROUND-OFF Value

    Hello guys,

    How do you round-off a value with 2 decimals places only?

    I have already format the textbox for this data type but it still displays 10 decimal places...please help?
    Last edited by Hack; Apr 19th, 2007 at 05:41 AM. Reason: Added RESOLVED to thread title and green resolved checkmark
    Reply With Quote Reply With Quote
  2. Apr 19th, 2007, 04:16 AM #2
    robbedaya
    robbedaya is offline
    Fanatic Member robbedaya's Avatar
    Join Date
    Jul 2002
    Location
    Belgium
    Posts
    872

    Re: How to ROUND-OFF Value

    Code:
    1. yourvalue = Round(yourvalue, 2)

    2. or

    3. yourvalue = Format(yourvalue, "0.00")
    Reply With Quote Reply With Quote
  3. Apr 19th, 2007, 04:41 AM #3
    nancy_padillon
    nancy_padillon is offline

    Thread Starter
    Lively Member nancy_padillon's Avatar
    Join Date
    Mar 2007
    Posts
    70

    Re: How to ROUND-OFF Value

    thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width