Value changed when posted to cell

[Atroxell]

HI,

I have a macro that places a values into a variable named "Yield". The value is safely passed to the variable. When the value is later posted to a different cell, the value is slightly different. When using the watch window, I see the variable correctly housing the value, even after posting it to the cell.

By example:

...
Dim Yield as Single
.
.
.
Yield = ActiveCell.Offset(0, 1).Value        [COLOR="Red"] 'At this point the value is 0.4[/COLOR]
.
.
.
ActiveCell.Offset(-2, 1) = Yield              [COLOR="red"] ' Suddenly, the value is 0.400000005960464 when viewed in the cell.[/COLOR]
...

What causes it and how do I correct this?

TIA

 

[Jerry Sullivan]

Hi Atroxell,

Try declaring Yield as a Double data type instead of a Single.

My understanding is that Excel stores cell values as Doubles, so when you read a cell value into a Single, a conversion must be done.

(Why Excel converts 0.4 to 0.400000005960464 is beyond my understanding).

Nonetheless, if you use a Double, it will work correctly.

 

[Atroxell]

Wow. That simple! Worked perfectly.

One of these days I am REALLY going to sit down and read ALL of the info on data types...

Thanks for your response!