I was just curious if there was a way to take all the values that have a minus sign on the right side of a cell and put it at the front? I downloaded a spreadsheet from my bank. all the negative values are formated
for example:
$1234.00 -
instead of:
-$1234.00
so excel doens't see them as negative numbers. I think it sees them as text because there's a space between the number and the negative sign.
I'm sure there has to be a way to move that character with out copy/pasting each value manually. The main problem is the values all are different length. I'm not sure how to handle that. Any one have any ideas? Thanks, Ian
Bookmarks