Losing significant digits when multiplying???

[brl8]

Hi All,

I have a question which hopefully has a simple answer. Why when I multiply two numbers together am I losing all significant digits after the decimal point. I'll show you my code, I'll show you what I want to happen and then I'll show you what is happening. Thanks so much for reading.

Here is a small snippet of my code:

Please Login or Register  to view this content.

So, if you look at my code above, result is 5,020,861
Cells(row + 4, 5).Value is 6.83947883572414E-06 (or 0.00000683947883572414)

The result I would like to get is: 34.3 (34.3400........... formatted to have one decimal place).

What I AM getting is 34.0 (newresult is 34).

Is it because I am multiplying by a single and do I need to cast this to another data type before multiplying? Help!!

Thanks!
BRL

[shg]

The variable newresult is declared as a Long, which is a whole number (a 32-bit signed integer).

Cells with numeric values are Doubles.

[brl8]

That was it! You rock! Thank you!!!!