Printing array values as integers not doubles

**sunita** · 06-03-2010, 05:17 PM

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.

**romperstomper** · 06-03-2010, 06:02 PM

Integers are whole numbers and don't have decimal places, so I don't really follow.

**sunita** · 06-04-2010, 03:33 PM

Dear Romperstomper,

Well, I guess what I am asking then, is how to print numbers with only 2 decimal places to the screen.

Cheers
Sunita

**romperstomper** · 06-04-2010, 03:41 PM

Use something like:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

to round to 2DP.

**sunita** · 06-04-2010, 04:18 PM

this worked like a charm!

just another question on formatting--- how do align this same array output in the message box so that it is all right aligned?
is there a simple way to do this?

thank you!!
sunita