View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
[email protected] fiazidris@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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.