My problem is i have 2 sort of format in one column and i want them all 1. 3287373382 2. NC128TRIPSM

[Mashail]

My problem is i have 2 sort of format in one column and i want them all 1. 3287373382 2. NC128TRIPSM I used this fomula: if Text.Length([SKU]) > 0 then [SKU] else "Invalid SKU" But then it gives me this error “ we can not convert the value 3837378332 to type text. Details: Value= 6.136362E+11 Type=[Type] My SKU is importing as scientific notation as well. 

[vicky_]

Is this a power query issue? If so, keep the [SKU] column as type text by going to the changed type step and editing the formula

Table.TransformColumnTypes(#"Removed Columns",{{"SKU", type text}, ... etc.)

 Based on the error message, I assume that your column is now an int or float type, so you can't use String operations such as Text.Length().