Output column with 2 data types into excel

[Frndly]

I have a column that consists of string and numeric data, and I need to output it into a template excel file. Said excel file has different formulas that calculate values based on data.

The problem is that numeric data is outputed as string data in excel, so formulas based on numeric data don't work. Is there a way to output it in the excel and somehow update or refresh numbers?

[OTrieger]

@Frndly 

One way to do it is to save the data into ranges, in this way you can save string as string and numeric as numeric, it will only require that you will output the data multiple times to different ranges.

[Frndly]

I considered it. The, but there's no consistent range of numeric\string data. I've attached an example. Distribution of numeric\string data can be considered random, although the amount of cells(height\width of the table) is consistent. 

[abacon]

Is there a way to put a 'ISNUMBER' formula into your excel? I don't believe there is a way to output he numbers as numeric in a string column from alteryx to excel but you can change you excel formulas to check if the values are numeric using the ISNUMBER function.

[apathetichell · Accepted solution]

when @OTrieger wrote "One way to do it is to save the data into ranges" this was a polite shorthand for "You must write to specific cells/ranges and preserve formatting --- google how to use an excel template and blob tools to make new fields if  needed. You must know the underlying formatting of the cells you are trying to write to and the specific location."

The above is the way. It is the only way. Learn how to do it - or figure out another workaround in Excel.