Converting Negative Numbers to Positive
 

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

=ABS(A1)?


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

check out ABS in help

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

Well, you could subtract the negative number from itself, then subtract
it again...

If you mean "a way to do this other than a formula", then one way:

Edit/Replace

Find what: -
Replace with: <leave blank


In article ,
bmmclen wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

bmmclen wrote:
There has to be a way to do this other than multiplying by -1???

Cell A1 enter a negative No.


in another cell enter =ABS(A1)


Answer is positive No.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

Converting Negative Numbers to Positive
 

another thought occurs

=SQRT(A1*A1)

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

How about

=IF(A1*A1=1,A1*A1,SQRT(A1*A1))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike" wrote:

another thought occurs

=SQRT(A1*A1)

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

=MID(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("A1: A"&LEN(A1))),1))),255,ROW(INDIRECT("A1:A"&LEN(A1)) ))),99)

entered as an array

"Dave F" wrote:

How about

=IF(A1*A1=1,A1*A1,SQRT(A1*A1))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike" wrote:

another thought occurs

=SQRT(A1*A1)

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

Nice to see the minimilist method is the only solution
:)
My answer to the original is Why, what's wrong with * (-1) ?

Steve

On Wed, 07 Feb 2007 15:17:00 -0000, Mike
wrote:

=MID(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("A1: A"&LEN(A1))),1))),255,ROW(INDIRECT("A1:A"&LEN(A1)) ))),99)

entered as an array

"Dave F" wrote:

How about

=IF(A1*A1=1,A1*A1,SQRT(A1*A1))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike" wrote:

another thought occurs

=SQRT(A1*A1)

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???

Converting Negative Numbers to Positive
 

On Feb 7, 3:48 pm, SteveW wrote:

.... what's wrong with * (-1) ?

ABS(A1) or SQRT(A1*A1) will generate a positive result whether the
origininal number in A1 is +ve or -ve.

*(-1) only returns a +ve result if the value in A1 is -ve.

Regards,

Alan