Results 1 to 6 of 6

Unwanted Rounding

Threaded View

scottintexas Unwanted Rounding 02-07-2014, 03:37 PM
etaf Re: Unwanted Rounding 02-07-2014, 03:48 PM
Olly Re: Unwanted Rounding 02-07-2014, 03:49 PM
judgeh59 Re: Unwanted Rounding 02-07-2014, 04:12 PM
scottintexas Re: Unwanted Rounding 02-07-2014, 05:39 PM
etaf Re: Unwanted Rounding 02-07-2014, 05:41 PM
  1. 02-07-2014, 03:37 PM #1
    scottintexas is offline
    Registered User
    Join Date
    05-22-2008
    Posts
    74

    Unwanted Rounding

    I was stepping through some code and found that the values are returning rounded numbers from the Cell to my variable, even though the cell has a two decimal place number.
    The value of the Cell in the following assignment is 776.38. After execution the value in varMileageExp is 777. 

    varMileageExp = .Cells(21, lngBilledMileageExpense).Value
    I have never noticed this before and can't figure out how to make it right.
    What's the deal?
    Last edited by alansidman; 02-07-2014 at 03:58 PM.
    Scott
    The harder it gets the happier I am.
    Finally got my signature set up!
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unwanted rounding
    By darkone1965 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2013, 12:00 AM
  2. Unwanted Rounding
    By IntegraCraig in forum Excel General
    Replies: 12
    Last Post: 10-30-2010, 03:35 PM
  3. [SOLVED] Unwanted rounding of large number
    By Candyman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. [SOLVED] Unwanted rounding of large number
    By Candyman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Unwanted rounding of large number
    By Candyman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1