I just imported a very large text file where the numbers were formatted with
a trailing sign so I now have sells which look like this 000478-. I'd like to
change that so thet they are -478. I've been doing it manually, but I figured
a macro to search the entire spreadsheet would be much more efficient. All of
the numbers are 7 characters with the 8th position being the sign. There are
also many numbers that were either 0 or positive which imported just fine, so
I need to leave them alone. Any suggestions as to how best solve this?