Issue with column data type and showing errors

Hi Experts,

I am facing an issue with the data type for the column below :

From the data source (Sharepoint list) , also having whole numbers , in that case i dn't know which data type to choose from power query.

I cannot able to fix this as i have tried to change data type into "text" but still it is not fixed. showing errors of 369 rows .

Please help to fix this asap

Thanks

DK