Microsoft.Jet.OLEDB.4.0 Excel help!!!

[esuk459]

This question is more to Microsoft.Jet.OLEDB provider rather than the VB itself. But since i couldnot find the right forum, I hope you still can help me.

I am faced with the following situation:

One person gave me this decimal number on excel spreadsheet, "2.6733". The person format the decimal to be formated using 2 digit instead. Hence outputting "2.7"
I load the spreadsheet onto ASP VB using Microsoft.Jet.OLEDB.4.0. The output on the ASP is of course "2.7".

I heard that Excel' internal mechanism stores data differently with its presentation. In this case, although excel display "2.7" on the spreadsheet, it retains the original value which is "2.6733".
My problem is:

- Is there anyway we can get the original value to be displayed on ASP using Microsoft.Jet.OLEDB.4.0.

Thanks for your attention.

ESUK

[wengang]

WHy is it rounding to one decimal?
Have you tried using ROUND(number, decimal places)?
it works in excel and in ASP