vbscript change values from excel into integer

[cowcool]

I finally able to read values from excel file, there is however one big problem (have spent 1 full day just to solve this problem)

The issue is vbscript see all numbers in excel file as integer

e.g.
=====
0.5 is treated as 5
1.75 is treated as 175
and so on .......

I Have tried csng, cdbl .... but it is not working, VBScript seems to ignore csng and cdbl in this case.

How to solve this problem?

Thx!!!

 

[PHV]

Any chance you could post the relevant code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886