Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Dim a Decimal

  1. #1
    Join Date
    25th April 2005
    Location
    Oakland,New Jersey
    Posts
    514

    Dim a Decimal

    how come this feature is not available? How do I DIM a decimal? As a Variant?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Dim a Decimal

    Try Double or Single.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,434

    Re: Dim a Decimal

    Try this
    VB:
    Option Explicit 
     
    Sub test() 
        Dim x As Double 
        x = 5 / 2 
        MsgBox x 
    End Sub 
    
    
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  4. #4
    Join Date
    25th April 2005
    Location
    Oakland,New Jersey
    Posts
    514

    Re: Dim a Decimal

    thank you fine sirs worked great

    (just working up that beer count aren't you Roy...)

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,434

    Re: Dim a Decimal

    You will never set foot in the UK I suspect, you will have to buy a brewery.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Convert Decimal With Comma To Decimal With Point
    By neverland in forum EXCEL HELP
    Replies: 4
    Last Post: June 3rd, 2011, 19:11
  2. Replies: 2
    Last Post: August 8th, 2008, 18:17
  3. Round Decimal Number Based On Decimal Portion
    By sk8salomon in forum EXCEL HELP
    Replies: 2
    Last Post: February 8th, 2008, 12:17
  4. Calculate Decimal Portion Of Decimal Number`
    By combsgroup in forum EXCEL HELP
    Replies: 2
    Last Post: June 11th, 2007, 12:28
  5. Replies: 9
    Last Post: August 3rd, 2006, 14:49

Bookmarks

Posting Permissions

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