importing data with negative sign at end of no.
Posted by Kara on October 12, 2001 11:45 AM
I imported data into excel that had the negative sign at the end of the no. (ie. 100-) . I tried to set up a macro to put the - sign in the front of the no. but was having trouble with referencing the cell.
the steps I took were
1. Find "-"
3. Backspace (to delete -)
But when I would run the macro, it would find the next -, but it would not perform the function in the active cell, but input the no. that was in the cell I recorded the macro from.