Direction of the query pane is Right to Left

Copper Contributor

I have Excel 365

When I open QUERY and want to write a formula in a custom column, the column is right to left and I can't change , AND CAN'T WRITE FORMULAS!  Although I am in Israel, the computer is set to English, in Excel and in the Control panel. 

how do i change the direction of the pane?

Thanks UDIT

QP RTL.pngQP RTL2.png

 

2 Replies

@Rami-udit 

And what is your locale for Power Query itself? (Data->Get Data->Query options)

image.png

Problem solved. we Changed the Window setting to English, That helped and now the Query is Left to Right.