Roberto P. Well-Known Member Licensed User Longtime User May 4, 2015 #1 Hello everyone, someone help me understand why I can not format this number? Here example: Number: 2.220446049250313E-16 Format 1: NumberFormat (Number, 2.3) result = 00,000 Format 2: NumberFormat2 (Number, 2, 3, 5, True) result = 00.00000 where am I wrong? thanks
Hello everyone, someone help me understand why I can not format this number? Here example: Number: 2.220446049250313E-16 Format 1: NumberFormat (Number, 2.3) result = 00,000 Format 2: NumberFormat2 (Number, 2, 3, 5, True) result = 00.00000 where am I wrong? thanks
klaus Expert Licensed User Longtime User May 4, 2015 #2 Your number 2.220446049250313E-16 is equal to 0.0000000000000002220.... So if you round it to 3 or 5 decimals it shows 0 ! Upvote 0
Your number 2.220446049250313E-16 is equal to 0.0000000000000002220.... So if you round it to 3 or 5 decimals it shows 0 !
Roberto P. Well-Known Member Licensed User Longtime User May 4, 2015 #3 oops, I missed the value of numbers thanks Upvote 0