Decimal Value in datatable

[Kuldeep_Pandey]

Hi
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

[Anil_G (Anil Gorthi)]

@Kuldeep_Pandey

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

I hope with this the issue would be resolved

Cheers

[Kuldeep_Pandey]

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

[Anil_G (Anil Gorthi)]

@Kuldeep_Pandey

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

Ches

[Kuldeep_Pandey]

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 ?

[Anil_G (Anil Gorthi)]

@Kuldeep_Pandey

(CurrentRow(5).ToString+CurrentRow(6).ToString

@Kuldeep_Pandey

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

cheers

[Kuldeep_Pandey]

Thankyou for your support