In that case, you could prepare a sheet in advance by setting the format of all cells to text. Shortcut sequence Ctrl+A Ctrl+1 Tab T T Return. You can record this as a macro (Developer tab) or save the result as a template.

Yes, the default format behavior can be annoying, but if it's a frequent problem there are ways to make one's life easier.

Excel has "paste with text import wizard" functionality where you can explicitly define the types your columns. For even more control try powerquery.