Can alteryx read currency cell formatting from excel?

[AkisM]

My input data has numbers in it, which are manually formatted in excel to show the currency symbol next to them. The default behavior of Alteryx as far as I know is to read the plain data from each cell, ignoring any formatting. So in the process, while alteryx does read in the value and recognizes it as a number, I'm losing the currency symbol.

My question is, is there a way to read in the currency symbol as well which is the result of excel's built-in currency cell formatting, or is my only choice to add a separate currency column in my input data?

[binuacs]

@AkisM you should add the currency symbol separate in your data, I also think Alteryx read the excel data as plain and ignores any formatting. 

[ArtApa]

Hi @AkisM - If you want the amount to remain a numeric data type, you need to add a separate column with a currency symbol. However, if you want to read the symbol from your excel file there is a way you can achieve it. You can use a Run Command tool that will save your Excel file as a csv file and then you can read the csv, which will give you a string value with a currency symbol.