Truncating Decimals

[RidgeView]

I have a macro whereby I have cells each a with number that could be upto 2
decimals in length. Example: A B C
8 5.6 7.25
Creating a variable accessing these cells the results is as follows:
8 5 7

WHAT DO I NEED TO DO TO MAINTAIN THOSE DECIMAL POSITIONS? i AM USING EXCEL
2007.

Thanks in Advance.....

 

[Jacob Skaria]

What is the variable type used ('Integer' or 'Long').
Declare the variable as 'Variant' or 'Double' and try

or just try
Msgbox Range("A1")

If this post helps click Yes

 

[RidgeView]

I tried "Variant" and it worked perfectly... Thanks alot !!!!!