Problem with auto detected data types from Excel file

Hi 

I am having a similar issue. Using BPI desktop, when I import an excel "Table", not sheet, I lose the currency formatting and the cells are changed to decimal. Becasue PBI only lets you format one column at a time it would be a nightmare to approach it from that angle. Is there a setting I can look at so I do not lose my excel formatting during import?

Thank you,

Steve