c# - Getting cell value loses the comma in the string? -

i'm using following line read value excel worksheet:

cellvalue = (sheet.cells[row, 13] range).value.tostring(); 

in particular case, value in cell looks this: "100,110". basically, 2 number separated comma.

when read cell value, cellvalue variable value ends being: "100110".

i have have comma because need split numbers array use later on (in instance, i'd have array 2 elements; 100 , 110).

what can when read cell, value "100,110" instead of "100110"?

the .value property returns double numeric values (including dates) , not take formatting consideration. it's translating comma-delimited list single number. can use .text property extract formatted value.