Convert output format from text to number with $ in excel

[fullmoon558]

Hi,

Please help me with this issue. 

I used this formula "'$' + TOSTRING(ROUND[Column A],0.01),2,1)" to add "$" and converted number to accounting format in Alteryx. I outputed the data into EXCEL. It shows like following with green triangle on the top left of each cell. If I click the cell, it also shows the following message "Number Stored as Text". 

I have to generate the data without this format, which likes the following. I know I can convert the data to the proper format by clicking "Convert to Number" in above figure. But I don't know how to achieve this in Alteryx. 

[geraldo]

@fullmoon558 

you can use the report tools like table tool

[dYoast]

@fullmoon558  - Change your formula to add an equals sign at the front.

"'=$' + TOSTRING(ROUND[Column A],0.01),2,1)"

This will make Excel think it is a formula and not give the error.

[fullmoon558]

Hi, thanks for your tips. I tried modify my formula in Alteryx as this "'=$'+TOSTRING(ROUND([Column3]),0.01),2,1)" then I ran the workflow. In Alteryx the results shows like this "=$92,000,000.00" and in my excel output file it all show as blank for the columns that I modified the formula. Is there anything I did wrong?