I don’t know if you’re aware of it, but if you want unaltered text content in an Excel cell, prefix it with a single quote ('). This “escapes” the value so that it isn’t interpreted as any other data type.
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.
