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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks