VBA to center specific character

[Nlreid]

Hi,

I am running a macro that formats 6 worksheets of data that I import from SSRS. When a "-" shows up in a cell, it is right aligned. I want to write into the macro that every time a "-" shows up anywhere, I want it center aligned. They can show up really anywhere, dependent on that run's data. Is this possible?

Thanks in advance,

Niki

 

[texasalynn]

so how is the cell formatted? Is it really a "-" or from a 0 being formatted as currency?