In a query you can't - sorry it is just a limitation of Access (datasheet view).

The only way to accomplish it would be to create a continuous form from the query data.  Then you can format the fields to suit.

You could convert it to text and then it will align left, but now it's text. Use Cstr.