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?

norie,

i am confused................

if i do the following in the code

Please Login or Register  to view this content.

junk2 will be displayed as 0.894.............this tells me that junk2 does not have to be an integer

any thoughts?

you are correct that if i change the data type to double then i get the desired result but ......dont understand

norie.........see enclosed macro........if you run it the 2nd dialog box shows a number like 0.894 which is not a whole number or integer

you're right...........ahhhhhhhhhhhhhhhhh

so sorry about that...............guess thats why it helps to have someone review your code sometimes.............

appologies..........thanks for your help.