Type change Error

[colourfullife]

Hi,

When i tried to change the type of weight coloum to number, it become error.

i checked that there is nothing apart from number in the coloum..! Not sure what's wrong.. Please Help.!

Thanks, 

[d_gosbell]

If you click on one of the "Error" values it will show you the full error message. That should give you more information on what is going wrong (maybe there are trailing spaces or something like that interfering with the type conversion). If not post the error message back to this thread.

[colourfullife]

Hi,

this is the message..

[v-cherch-msft · Accepted solution]

Hi @colourfullife 

You may try to change the 'Locale for import' as below.Here is the blog for your reference.

Regards,

[d_gosbell]

Maybe you have some trailing whitespace. Try trimming the column before changing it's type

[colourfullife]

Hi,

this is the message..