try otherwise inside Table.TransformColumnTypes

[Fcoatis]

Ok, here is what I´m trying: Change the type number with Locale settings if I got error keep the local number type:

Something like:

= Table.TransformColumnTypes(#"Changed Type with Locale", try each {{"Patrimonio", type number}}, "en-US" otherwise {{"Patrimonio", type number}})

Thanks in advance

[v-janeyg-msft]

Hi,  @Fcoatis 

Sorry. Two formatting types can’t exist in the number type field at the same time, the formatting affects the entire field. Only text types can.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Is the difference between the numbers the presence of "," or "." in the number?  If so, you could just Replace Values ahead of the data type change to avoid the error.

Pat

[Fcoatis]

Just can´t I have both formats with "." and ","