+ Reply to Thread
Results 1 to 8 of 8

range.Value = a() chopping off decimals

Hybrid View

  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: range.Value = a() chopping off decimals

    That's what it was. I populated the array from a range formatted currency 4 decimals.
    It bothers me that even though the array had 4 decimals in it, it only pasted 2. Seems like a bug in Excel.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: range.Value = a() chopping off decimals

    Nah, it's a 'feature'...
    You should also be able to use the Value2 property to get doubles passed to the array instead.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: range.Value = a() chopping off decimals

    Quote Originally Posted by romperstomper View Post
    Nah, it's a 'feature'...
    You should also be able to use the Value2 property to get doubles passed to the array instead.
    Never used Value2 before. Looks like it solves the problem, so I don't have to worry about how the range is formatted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1