Hi @BobSievert ,
I believe this posts solution by @danilang answers your question
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Problem-formatting-date/td-p/467212
The issue arises from opening a csv file with Excel, which applies its own formatting rules. If you open it with a text editor, the values are displayed correctly
Hi @BobSievert
How irregular or wrong would it be to have these values output with a ' or space as a prefix using:
"'"+[Field_1]
or
" "+[Field_1]