Output to Numbers instead of Text in excel output

Question

Hi! I'm exporting some data as excel output and for few columns which are actually "double" values in alteryx output when exported are converted into "text" in the excel. I need to manually then convert them into numbers in excel which is frustrating.  So is it possible to directly export these values as numbers into the excel instead of text?

Some help or guidance is appreciated. 🙂

Thanks!

Best,

Rohan

rrohan90 · Answer

Thanks John

dataguyW · Answer

You have text and numbers mixed in the same columns so it is trying to figure it out.  One trick I use was to just acknowledge that Excel does some conversions I didn't want and export my data to CSV (all text).   I then used Imports to Excel/Access where I could specify how it was to be treated.  I wish Excel had a "trust me, I got this" button where it would just stop trying to convert to what it believes is correct.   Your other option would be a macro to assign data types, but that is a pain.