H hdmiacc Member Licensed User Longtime User Nov 24, 2013 #1 hello all.. example of my program enter value1 = 9.99x10^-12 enter value2 = 9.99x10^-12 value total = 9.979999999999999E-23 how question is : how to make value total = 9.98E-23
hello all.. example of my program enter value1 = 9.99x10^-12 enter value2 = 9.99x10^-12 value total = 9.979999999999999E-23 how question is : how to make value total = 9.98E-23
stevel05 Expert Licensed User Longtime User Nov 24, 2013 #2 Have a look at NumberFormat and NumberFormat2 here Upvote 0
H hdmiacc Member Licensed User Longtime User Nov 24, 2013 #3 stevel05 said: Have a look at NumberFormat and NumberFormat2 here Click to expand... already use numberformat.. but got 0.0 if after E is negative.. but if after E is positive it now the correct answer Upvote 0
stevel05 said: Have a look at NumberFormat and NumberFormat2 here Click to expand... already use numberformat.. but got 0.0 if after E is negative.. but if after E is positive it now the correct answer
M Mahares Expert Licensed User Longtime User Nov 24, 2013 #4 Code: Copy Dim MyString As String="9.979999999999999E-23" Dim strVar() As String=Regex.Split("E",MyString) Msgbox("My result is = " & NumberFormat(strVar(0),1,2) & "E" & strVar(1),"") 'displays: 9.98E-23 Upvote 0
Code: Copy Dim MyString As String="9.979999999999999E-23" Dim strVar() As String=Regex.Split("E",MyString) Msgbox("My result is = " & NumberFormat(strVar(0),1,2) & "E" & strVar(1),"") 'displays: 9.98E-23
H hdmiacc Member Licensed User Longtime User Nov 24, 2013 #5 Mahares said: Code: Copy Dim MyString As String="9.979999999999999E-23" Dim strVar() As String=Regex.Split("E",MyString) Msgbox("My result is = " & NumberFormat(strVar(0),1,2) & "E" & strVar(1),"") 'displays: 9.98E-23 Click to expand... thanks.. after edit your code.. i got what i need.. thanks again Upvote 0
Mahares said: Code: Copy Dim MyString As String="9.979999999999999E-23" Dim strVar() As String=Regex.Split("E",MyString) Msgbox("My result is = " & NumberFormat(strVar(0),1,2) & "E" & strVar(1),"") 'displays: 9.98E-23 Click to expand... thanks.. after edit your code.. i got what i need.. thanks again