Depending on how you're importing the data, you may see the text to columns
wizard.

And in xl2003 (for sure, maybe xl2002???) and greater, you'll see an advanced
button on step 3 of the wizard.

There's an option to treat those trailing minuses as negative numbers.

If your data is already in place, you can use data|text to columns and start
that same wizard (again xl2003 (or xl2002???) or later.

tracytracy123 wrote:

Our system reports unfortunately have negative signs in back of numbers
instead of in front. When we export them to Excel, the negative numbers seem
to be ignored in totals and we are manually moving the negative signs from
back to front to get our totals correct. Is there a way to do this faster?

--

Dave Peterson