Convert table to list (Number)

[samahiji]

Hi
I have the following code to convert sheet range to number in power query,
The range named "Tests" would accept any thing except number.
I know there is minor change I have to do, but I couldn't figure it out.

let
    Source = Excel.CurrentWorkbook(){[Name= "Tests"]}[Content],
    MyList= Table.ToList(Source){0}
in
    MyList

 

[GraH]

You use {0} as index, this will return the first element. If the table contains a single column with numbers you'd like to concert to a list, you can use table[columnname]. This will return a list.