Issue with Chase downloading a years transactions

[joh1135]

I have been trying to figure out why Chase transactions do not down load properly into Excel. After a couple of hours I downloaded the document into word with using past with document formatting and it showed me that Chase places a question mark in front of the number if the number is negative (?$1,000.00).

So now I need some help with VBA to remove the ? and replace it with a - in column E. I tried to use Record a macro but I could get it to do both actions. I have 300 transactions and i would hate to have to do it manually.

Any help will be greatly appreciated

Thank you

 

[sandy666]

maybe:
Find: ~?
Replace: -

 

[joh1135]

I will give it a try - Thanks

 

[sandy666]

Welcome