Decimal Value in datatable

My decimal no is changing in integer value
I dont’t Know why its happeining Please help me to figure out this

I have used this to change my text format things in number


Cint() is for converting to integer…if you need decimal please use CDBL()

I hope with this the issue would be resolved


Is It give me both Decimal or interger ? Because I have both in my excel row


Yes cdbl will handle both the types…integer is also a kind of decimal only with zero decimal values


But again not getting decimal value
{(-1*Double.Parse(CurrentRow(5).ToString+CurrentRow(6).ToString,System.Globalization.NumberStyles.Any, System.Globalization.NumberFormatInfo.InvariantInfo)).ToString(“#,0.############”, System.Globalization.NumberFormatInfo.InvariantInfo)}
I have used this also to change opposite sign of no
Is any thing in this query i have to change ?


The above one as you are adding strings it will add strings but not like numbers


Thankyou for your support

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.