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
Bookmarks