Changing Data type in Edit Queries or Modeling

Hi,    I am getting data from Excel sheet and some of the field's data type needs to be to changed. I have always done this modification through Edit Queries. However, it was not reflecting the cha...