Issue in Lables while Printing the Output

[Dheepak]

Hi All,

I need a your help on below issue.

Value of Label 1 is 50
Value of Label 2 is 50.01

When i print the difference result in label 3 its showing as 9.99999999999801E-03 but it should print 0.01

Here is the code that i wrote.

Code:
Label3= Label2-Label1

Could you please help me how to print the correct value and also code.

Thanks in Advance!!!!

Regards,
Dheepak

 

[sijpie]

Label3 = Format(Label2-Label1,"0.00")

with the Format() function you can format any numbers or date/time exactly like on a spreadsheet with the number formatting

Format(Date,"yyyy-mm-dd") 2013-10-15
"Invoice - " & Format(1,"000") Invoice -001
etc