First off, I think you intended to post this question to the Access forum. Maybe a moderator can move it there for us?
If importing a file from Excel, Access automatically takes whatever the format Excel has the data in. I don't think you have any ability to select/change it via the Import Wizard (believe me, I've tried)! The best way to handle it is to format the Excel file appropriately first.
Another option, one that I have used a lot because you often get many more errors importing from Excel directly, is to save your Excel file as a Text file first, then import the Text file into Access. Then you have "control" over the format of the fields through the Import Wizard.
I would go about this a little differently. Instead of trying to change the format directly in the table, or via a Make Table Query, why not just convert the field from Numeric to Text in a query (using the FORMAT function, which is similar to Excel's TEXT function), and use the query for report/form/calculation purposes? Then you never have to worry about manipulating/massaging that field every time it comes in. Here is an example of a query calculation that will convert a Numeric entry to Text.