Hi @jn93 ，
You can add a apostrophe in front to force Excel to show it as text instead of a numeric value.
Use SSIS Derived Column Transformation with below expression:
"'" + <yourColumnName>
Or you may open the csv file with notepad, it will not show the Incorrect Format.
If the answer is helpful, please click "Accept Answer" and upvote it.
No more question. Thanks for the answer.