Convert output format from text to number with $ in excel

Question

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.

fullmoon558 · Answer

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?

dYoast · Answer

@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.

geraldo · Answer

@fullmoon558

you can use the report tools like table tool

value.yxmd