I have a spreadsheet that has negative and positive dollar amounts in the same column and I would like to separate them, moving the negative amounts one column to the right.
So
E
$900
$200
-$23.98
$100
-$5.67
-$88.99
Would be
EF$900
$200-$23.98$100-$5.67-$88.99
If anyone has a macro or if/then formula that would automate this that would be perfect!
Thanks.
Bookmarks