Change negative nmbr to positive
 

I have a table of numbers, some positive, some negative. Is there a way so
remove the "negativity" and change the number to a positive?? Would like to
do without altering the table of numbers or adding extra formulas.

Got me puzzled..

Thanx
Tom

Change negative nmbr to positive
 

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

Change negative nmbr to positive
 

Well... That would have worked swell but there are hyphens in some of the
part descriptions and part numbers... It's the negatives inthe quantity
fields I need to change....

"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

Change negative nmbr to positive
 

Select the columns with your quantities in them (if more than one column,
Ctrl+<click their headers to select them) and then follow the Edit/Replace
instructions Dave posted.

Rick


"Tom" wrote in message
...
Well... That would have worked swell but there are hyphens in some of the
part descriptions and part numbers... It's the negatives inthe quantity
fields I need to change....

"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

Change negative nmbr to positive
 

Hi Tom,
Depending on how big your numerical data table is, you can do the Replace
thing, but just step through it by using Find Next, Replace, Find Next,
Replace. You can speed this up by selecting the first cell in the table, and
selecting By Rows or By Columns, as appropriate.
Regards - Dave

Change negative nmbr to positive
 

Maybe...

Select the range to fix -- include text and numbers
Then Edit|Goto (or hit the F5 button)
Select constants
and check numbers, but uncheck the others (text, logicals and errors)

Then do the edit|replace against that subset of the original range.

Tom wrote:

Well... That would have worked swell but there are hyphens in some of the
part descriptions and part numbers... It's the negatives inthe quantity
fields I need to change....

"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

--

Dave Peterson

Change negative nmbr to positive
 

Not necessarily elegant:

Say your numbers are in column B.

Add a column, let's say Column Z.
Z2=ABS(B2)
Z3=ABS(B3)... and so on.

Then, COPY Column Z,

Highlight Column B,

PASTE SPECIAL/Values

"Tom" wrote:

Well... That would have worked swell but there are hyphens in some of the
part descriptions and part numbers... It's the negatives inthe quantity
fields I need to change....

"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.

Change negative nmbr to positive
 

Brilliant! I was trying to use formulas and kept winding up with an extra
unwanted column that confused everyone even if it was hidden.
Thank you!
--
Lisa


"Dave" wrote:

Hi Tom,
Select Replace from the Edit menu.
In the Find What field, put -
Leave the Replace With field blank.
Click Replace All (if there are no wanted negative numbers on the sheet)
Regards - Dave.