Excel VBA ".value" / Strange Behaviour!!!
Hi,
---
Test 1 returns
1851.99986485288
---
Test 2 returns
1852.00034359738
1852
General
1852.00034359738
1852
General
---
One additional problem I noticed today is when I want to type in the
code window for example:
TestVar = 350.23
What actually happens is...
Once I finish entering the last '3' and click [enter], the code window
shows as below:
TestVar = 350.228178550713
THIS IS VERY STRANGE!!!
----
I started Excel in Safe Mode by using the [Start] - [Run] - EXCEL.EXE
/S - [Enter].
Excel opens in [Safe Mode]
The results are same as above. No improvements at all.
---
Please give me some more suggestions so I may try. Thanks.
|