This frustrates me every time as well.
Intuit, please fix this obvious bug in your software.
When pasting a cell from excel with currency symbols in it, you should just ignore them!
