How do you convert 100- to -100?

  • Thread starter How to convert from 100- to -100
  • Start date
H

How to convert from 100- to -100

I have a spread sheet that instead of having -100 (negative 100), it shows
negaive 100 as 100-, is there anyway that I can convert this back to -100
faster by using a formular instead of typing it one by one, it's like 1000+
rows. Thanks.
 
G

Gord Dibben

Data>Text to Columns>Next>Next>Advanced

Make sure "Trailing minus for negative numbers" is enabled then hit Finish.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you convert 100- to -100 in excel? 3
Weighted % Complete calculation 1
Populating Forms from Excel or CSV file 0
Page Breaks 1
Comparing two lists in Excel 1
Custom Format with multiple conditonals 1
Possible to have multiple sheets refer to a master template sheet? 1
Sorting Numbers that have Text 2

Top