This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm hoping someone can help me out here. I have a column in Alteryx formatted as String which has values such as 10050-00, 11866-00, 138-00, 10-00, 3-00, etc.
Basically, when I output the CSV file into Excel, it will change 10-00 to Oct-00 and 5-00 to Mar-00 in a Custom Excel format instead of a General format like the others. Is there a workaround in Alteryx in order to prevent this from happening when the data is output? Here is my formula I'm currently using in Alteryx for this field:
Try outputting to an XLSX format instead. That should maintain the String data type (although it still shows the message..."This cell contains a date string represented with only 2 digits for the year.") :smileyindifferent:
Or if you really do need a CSV, I like a suggestion from the second link above...cheat and add a space before the values you are creating. Excel will then recognize as a string and keep the original format.