Hidden problem in cell content imported from Mac

[kcw]

I received a spreadsheet prepared on a Mac that contains 312 cells that only appear to contain currency-formatted numbers but which cannot be manipulated, every attempt producing an #VALUE error. (A further 468 cells lack the currency symbol and function just fine as numbers.) I'm running Excel 2016, v. 2011 on a Win10 Pro desktop.

Cell-formatting changes, or using the TRIM and VALUE and truncation formulas, cannot fix those 312 cells but, so far as I've discovered, *only* copying each cell's content separately to Wordpad, deleting the symbol, one heading space and two trailing spaces, and copying the result back into Excel.

Is there a 'wholesale', intra-Excel fix I'm unaware of?
MUCH obliged for any help, KCW

[6StringJazzer]

These are not numbers, they are text. Use global Find & Replace to delete all the "$" characters.

The last character is not a space, it's a code 160 character. To replace those, do find and replace typing ALT+0160 as the Find string (hold down the ALT key while typing all of those numbers, using the numeric keypad).

I did this on your sample file.

[kcw]

You NAILED it, 6SJ!
I need to learn about those invisible Alt+ characters. Did you know from experience or is there some way to detect those?
Great thanks, Kurt

[6StringJazzer]

I knew that they existed. The way I found it in your file was first I did a find and replace on space and nothing happened. Then I set up a formula like this on one of the cells to get the code:

=CODE(RIGHT(A1,1))

A space is 32 but this came back 160. Bingo.

I started developing software 40 years ago.