Results 1 to 3 of 3

Thread: Decimal

  1. Apr 14th, 2001, 04:59 PM #1
    rattack
    rattack is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2001
    Location
    Sunny Queensland
    Posts
    91

    Exclamation

    I noticed this answered in a previous thread but it did not work for me.
    If I do a calculation of entries in several text boxes and have a msgbox popup with the answer.How do I restrict the decimal places.Ie in one calculation I need 4 dec places and in another I want it restricted to none.At the moment it has about 20.
    Thankyou for any assistance.
    Reply With Quote Reply With Quote
  2. Apr 14th, 2001, 05:02 PM #2
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    Code:
    MsgBox Format$(number, "#0.####")
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  3. May 3rd, 2001, 04:41 AM #3
    Nucleus
    Nucleus is offline
    Registered User Nucleus's Avatar
    Join Date
    Apr 2001
    Location
    So that's what you are up to ;)
    Posts
    2,530
    or even easier is formatnumber(number, number decimal places)
    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