Required output with $ sign on salary column

[Spy3y3]

Good Morning, Afternoon, Evening, as your respected time,

I am connecting today with one help in Alteryx, I hope I will get it.

I am working on the project and there is one column named annual salary mentioned in the $ sign with we underscore string data type I used the select tool to try to change the data type into double but got the output as null.

Question: What is the average annual salary for each department in the dataset?

Require Output: With $ sign if possible

I would like to mention that I used the below-mentioned tools,

Input - Data Cleasing - Select - Summarize

Image 1:

Image 2:

Image 3:

 

Note: In the first image, I also removed the trailing whitespace

[CoG]

If those 2 date formats are the only formats, then you can just use the DateTime Tool (in Parse category) since it interprets "/" & "-" as effectively the same separator.

To answer your second question, it depends what the exact output your looking for is and what you have initially that you need to convert. The answer is probably, but more information is necessary to provide specifics.