question

Hi,

If I want to transform the data type of all columns in a table (the number and the name of the columns can change in the future).
In another question I found the following solution
let Source = Excel.CurrentWorkbook(){[Name="YourTable"]}[Content], LSTHeaders = Table.ColumnNames(Source), HowMany = List.Count(LSTHeaders), Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({type number}, HowMany )}))) in Transformation

It works fine but I don't know how to apply "en-US" data format.
I tried the following but didn't work:

  Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({
                 {type number}, "en-US"}, HowMany  )})))

Any help? Thanks