Except from personal experience I can tell you that even when you go out of your way to set the correct data types, if you try to copy paste any data into those

Except from personal experience I can tell you that even when you go out of your way to set the correct data types, if you try to copy paste any data into those cells excel will ignore everything you set and try to automatically change the data types. If you know how to get it to never do that sort of thing, please let me know, because this is causing major issues in production software...