I'm sure people might still be Googling for this answer, I did.
To format foreign currency out of Accounting:
Click cell -> select currency type from the Ribbon (automatically puts it in accounting format) -> Right click on cell -> Format Cells -> Number Tab -> Currency -> Symbol -> Click OK -> The "¥_____1,000" (with spaces) will now appear as "¥1,000"
Trying to select a foreign currency from the ribbon changes the cell to accounting, trying to change it back to currency changes it back to USD. This will fix that problem and make the cell summable, which is not if you use the alt code (alt 157) to type ¥.
If it's not summing, retype number and repeat the process.