Tayfur Well-Known Member Licensed User Longtime User Feb 10, 2014 #1 hello; I open my excel file and read cells. after I add some value. But, my code boken on data convert. We use in my contry double format => "1.123.456,2345" I dont have any problem when on AVD manager working at windovs. So, Code has a problem in my tablet. Code: Code: Copy ' Cell(1,2)="90,12" New_value=cell(1,2)+0.15 I looked my tablet setting. I didint find float setting. How can i fix it?
hello; I open my excel file and read cells. after I add some value. But, my code boken on data convert. We use in my contry double format => "1.123.456,2345" I dont have any problem when on AVD manager working at windovs. So, Code has a problem in my tablet. Code: Code: Copy ' Cell(1,2)="90,12" New_value=cell(1,2)+0.15 I looked my tablet setting. I didint find float setting. How can i fix it?
eps Expert Licensed User Longtime User Feb 10, 2014 #2 I think you need to break down the steps in your calculation to see the values and when they are getting corrupted. It feels like your issue is a numeric format issue. Upvote 0
I think you need to break down the steps in your calculation to see the values and when they are getting corrupted. It feels like your issue is a numeric format issue.
Tayfur Well-Known Member Licensed User Longtime User Feb 10, 2014 #3 eps said: I think you need to break down the steps in your calculation to see the values and when they are getting corrupted. It feels like your issue is a numeric format issue. Click to expand... how can i fix it Upvote 0
eps said: I think you need to break down the steps in your calculation to see the values and when they are getting corrupted. It feels like your issue is a numeric format issue. Click to expand... how can i fix it
Erel B4X founder Staff member Licensed User Longtime User Feb 10, 2014 #4 The decimal separator should be a dot. You will need to do something like: Code: Copy Dim cell As String =... cell = cell.Replace(".", "").Replace(",", ".") Upvote 0
The decimal separator should be a dot. You will need to do something like: Code: Copy Dim cell As String =... cell = cell.Replace(".", "").Replace(",", ".")
Tayfur Well-Known Member Licensed User Longtime User Feb 10, 2014 #5 Erel said: The decimal separator should be a dot. You will need to do something like: Code: Copy Dim cell As String =... cell = cell.Replace(".", "").Replace(",", ".") Click to expand... thank you Erel for your helps... Upvote 0
Erel said: The decimal separator should be a dot. You will need to do something like: Code: Copy Dim cell As String =... cell = cell.Replace(".", "").Replace(",", ".") Click to expand... thank you Erel for your helps...
