norie,

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

if i do the following in the code

dim junk2 as long
junk2 = 0.894
msgbox(junk2)
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