Long variable returning unexpected result which appears to be only integer value

hi,

Please find the enclosed macro.

I have a long data type (called junk1....see enclosed macro).

I assign the cell contents of B4 to this junk1 variable.

But for some reason the value sent to junk1 is 1..............when i expected it to be 0.893674293405114.

If i dont define junk1 as a long data type it works............

i am kinda confused..........i want junk1 to hold the number 0.893674293405114 and not the value of 1

any ideas on whats going on?