Excel - How to abs entire column

I'm new to Excel and would like to change all negative numbers appearing
in a non calculated column to positive numbers. The problem results
from a bug exporting Quickbooks Pro invoices to Excel, in the
"quantities" column, and would like a quick macro to fix, versus
changing each column entry to a positive number by hand.

Thanks,
John


---
Message posted from http://www.ExcelForum.com/

try
sub makeabs()
For Each c In Selection
c.Value = Abs(c.Value)
Next
end sub
--
Don Guillett
SalesAid Software

"John E. " wrote in message
...
I'm new to Excel and would like to change all negative numbers appearing
in a non calculated column to positive numbers. The problem results
from a bug exporting Quickbooks Pro invoices to Excel, in the
"quantities" column, and would like a quick macro to fix, versus
changing each column entry to a positive number by hand.

Thanks,
John


---
Message posted from http://www.ExcelForum.com/

Select the range and run this:

Sub ToPos()
Dim Cell As Range
For Each Cell In Selection
Cell.Value = Abs(Cell.Value)
Next
End Sub


--
Jim Rech
Excel MVP
"John E. " wrote in message
...
| I'm new to Excel and would like to change all negative numbers appearing
| in a non calculated column to positive numbers. The problem results
| from a bug exporting Quickbooks Pro invoices to Excel, in the
| "quantities" column, and would like a quick macro to fix, versus
| changing each column entry to a positive number by hand.
|
| Thanks,
| John
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|

John,

If your numbers are formatted -15, -125 etc. then
highlight the column containing the numbers and do an
Edit/Replace with a - in the 'Find what' and nothing in
the 'Replace with' and select replace all.

Charlie O'Neill
-----Original Message-----
I'm new to Excel and would like to change all negative
numbers appearing
in a non calculated column to positive numbers. The
problem results
from a bug exporting Quickbooks Pro invoices to Excel, in
the
"quantities" column, and would like a quick macro to fix,
versus
changing each column entry to a positive number by hand.

Thanks,
John


---
Message posted from http://www.ExcelForum.com/

.

Enter -1 in a cell.

Copy this then select your negative numbers(column of) and Paste
SpecialMultiplyOKEsc.

Delete the -1 from the the cell.

Gord Dibben Excel MVP

On Thu, 29 Apr 2004 09:05:30 -0500, John E.
wrote:

I'm new to Excel and would like to change all negative numbers appearing
in a non calculated column to positive numbers. The problem results
from a bug exporting Quickbooks Pro invoices to Excel, in the
"quantities" column, and would like a quick macro to fix, versus
changing each column entry to a positive number by hand.

Thanks,
John


---
Message posted from http://www.ExcelForum.com/

Thanks for all your help. Will put these ideas to work.
John


---
Message posted from http://www.ExcelForum.com/

Jim Rech cogitated deeply and scribbled thusly:

Select the range and run this:

Sub ToPos()
Dim Cell As Range
For Each Cell In Selection
Cell.Value = Abs(Cell.Value)
Next
End Sub


REALLY? The OP said he "was NEW" to Excel! Why not give the simple
solution like paste-special-multiply with -1 ?

--
gordonATgbpcomputingDOTcoDOTuk

To email me replace the obvious!