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
Sorting Numbers that have Text 2
Custom Formatting (# x 1000) 2
Sumproduct formula help needed 6
Doubt to use SUMPRODUCT with divice option.... 4
Locating row with no duplicate matching amount 1
finding unique values 2
Formula to replace nos. below 100?? 3

Top