How do you convert 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.

How do you convert 100- to -100?
 

DataText to ColumnsNextNextAdvanced

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


Gord Dibben MS Excel MVP

On Fri, 27 Mar 2009 14:28:01 -0700, How to convert from 100- to -100 <How to
convert from 100- to wrote:

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.