Render Tool outputting large negative numbers as text rather than numbers

[ixf23]

hi all. I am currently using the render tool to output data into an excel file. All of my data has been changed to 'double' using tonumber() formula and select tool but when I export my data, large negative values over 1 million (ex: -1,475,143.23) are reading in formatted as text in excel. This does not allow me to use any formulas on exported data. Does anyone have any solutions for this?

All smaller negative numbers and every positive number reads into excel as a number so I am not sure what is causing this. 

[apathetichell · Accepted solution]

try increasing the size of the page/sheet you are writing to in the render size options. My hypothesis is that this is a side effect of trying to write data in a field which is too small.

[ixf23 · Accepted solution]

I had to reset my Render tool and reset the size and it actually worked! Thank you so much for the help!!!

[apathetichell]

Chalk it up to the mysteries of the render tool...