Convert Imported Text Containing Dollar Sign to Numbers

Hi, I'm usually pretty adapt at Excel, but I can't figure this out and so hope someone can help!

I am copying a set of numbers from a website that when I past them in excel they populate in one column. The numbers are not able to be summed in their format (they are money, and the format is $ 16.00).

What I've been doing is manually writing the same number in the cell just to the right of the number.

When I do this, after 3-4 cells, Excel will show me the rest of the numbers - as though it was filling them in for me. My goal is to get it to do that, but I can't figure out how to 'grab' those numbers and have excel leave them. What happens inevitably is whatever I do, excel does not keep the numbers that it was showing me, and I have to manually type all of them.

I hope that makes sense without a picture. What I'm trying to do is get the numbers that are copied to sum in an easy way. It seems like there is an easy Excel function that knows what I'm doing and can do it for me, but I don't know why those numbers that it is showing me disappear or how to keep them.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As yo are dew, I shall do it for you this time.)

Administrative Note:

Please update your forum profile with the correct 'latest' version - either Excel 365 or Excel 2019 - they are not quite the same.

I think you missed this:

Administrative Note:

Please update your forum profile with the correct 'latest' version - either Excel 365 or Excel 2019 - they are not quite the same.

I think you would be better-served finding a way to import the numbers in a suitable format rather than trying to process them in this way. Which website are you copying from?