Hello all,
I am creating a tool which stores weighted average values for various indicators in an array. For the purpose of storing the data and doing the calculations, I needed to Dim array as double. However, I now want to print out my my array values as integer numbers with only 2 decimal places. Problem is, that when I print it out in a message box, the values I get have over 10 decimal places (because they are stored as doubles in the array). When I tried to use an integer array instead my weighted average values turned up as zero rather than the correct number. Is there some way to convert array output to integer numbers cell by cell?
Can someone help? Thanks so much in advance!!
Please Login or Register to view this content.
Bookmarks