I am downloading banking inofrmation to a spreadsheet. It downloads as a
negitive value. Is there a way to automaticly change this?

Not sure about automatic but one manual way.

Put -1 in a cell, select that cell and copy it.

Select all your cells with negative values then

Edit|paste special|multiply and click OK
delete the cell with -1 in

"TJR" wrote:

I am downloading banking inofrmation to a spreadsheet. It downloads as a
negitive value. Is there a way to automaticly change this?

Can you change the value at the source?

If not......................

Enter -1 in a cell.

Copy that cell then select your range of negative numbers and EditPaste
SpecialMultiplyOKEsc.

Not so automatic but you could record a macro to do this.


Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 09:36:03 -0700, TJR wrote:

I am downloading banking inofrmation to a spreadsheet. It downloads as a
negitive value. Is there a way to automaticly change this?

Mike H;2379173 Wrote:
Not sure about automatic but one manual way.

Put -1 in a cell, select that cell and copy it.

Select all your cells with negative values then

Edit|paste special|multiply and click OK
delete the cell with -1 in

"TJR" wrote:
-
I am downloading banking inofrmation to a spreadsheet. It downloads as
a
negitive value. Is there a way to automaticly change this?-

Mike,
Thanks for this simple trick. I was doing this the long way - Inseret
a column, multiply by -1, then copy and paste values. It worked but
some time it shows more digits than I care for.




--
ab3d4u

Hope this helps.....
Sub DelNegative()
For X = 1 To 1
Dim redRng As Range
Set redRng = Range("A1", Range("A100").End(xlUp))
For Each cell In redRng
If cell.Value <= 0 Then
cell.Value = Abs(cell)
End If
Next cell
Next X
End Sub


--
RyGuy


"TJR" wrote:

I am downloading banking inofrmation to a spreadsheet. It downloads as a
negitive value. Is there a way to automaticly change this?