Write column on csv to excel as number not a text

Learn Academy Feedback
, ,
1

hello all i need to copy data from a csv file to excel, i did it but the data of one column show as text format and as to change the format to number, can you help me please ?

Thanks in advance

2

Hello @Maroua302,

I think that happened because of the separator in the number, my solution was to loop over the entire DataTable and use Assign as follows:

row(“NumberCol”) = row(“NumberCol”).ToString.Replace(“,”,“.”)

Cheers :upside_down_face: