Date Formatting with text

Copper Contributor

I use Excel to create CSV files to port into documents in INDD. I need a full date such as October 2, 2019, and it always changes it to 2-Oct-19. This is so frustrating. I have to go in and change every date in the created document. Why does Excel just do whatever it wants after you input the information how you want it? And how can I make a change stick? This really holds up my general workflow. Thank you all in advance! Note: I have looked at other date formatting threads but its usually a number error without text. 

1 Reply
Modify the short date format in Region and Language in the Control Panel to “MMMM d, yyyy”.