I have this two value:
-16.285,15 -16.284,75
i get with:
....
dim DARE as double
Trim(Mid(CurrentLine, 85, 17) - Format(DARE, "#,##0.00"))
...
insted the difference is 0,34 i have
-0,399999999999636
Always the same problem
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Always the same problem
You can use Round(..., 2) to round the result to 2 decimal places.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4374
- Joined: 26 Apr 2010, 17:36
Re: Always the same problem
ahhhhhhh....HansV wrote:You can use Round(..., 2) to round the result to 2 decimal places.
you just post a solution in other my question, sorry for tath.
-
- PlatinumLounger
- Posts: 4374
- Joined: 26 Apr 2010, 17:36
Re: Always the same problem
HansV wrote:You can use Round(..., 2) to round the result to 2 decimal places.
hohohoh...
i have dimensioned Double IMPORTO....
now i have IMPORTO=-20503601554,92
when i process this var have "error overfloow"
How to dim correct IMPORTO?
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands