Hi,

I'm transporting data from a CRM into an excel sheet. There are values in the spreadsheet. When I export, the values always come in with 3 symbols preceding the value. Eg: ￥1,080,000.00. Can I create a macro to remove the ￥ symbols that appear?

I'm useless at excel, so full details on how to do this would be good.

Thanks