Multiply an entire spreadsheet by 1000 without going into ea cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacham - 08 Feb 2008 17:24 GMT

I need to multiploy a large spreadsheet with many values by 1000 with out
going into each cell. I would need to turn ea. cell from a value to a
formula.

Reply to this Message

Gaurav - 08 Feb 2008 18:16 GMT

I am not sure of how to turn all the values into formulas but you can
multiply all the values by doing the following.

Write 1000 in any of the blank cells
Copy that cell
Select the entire range that you want to change.
Right click
Paste Special
Multiply

>I need to multiploy a large spreadsheet with many values by 1000 with out
> going into each cell. I would need to turn ea. cell from a value to a
> formula.

Reply to this Message

Alden - 08 Feb 2008 18:45 GMT

What do you mean by formula?

> >I need to multiploy a large spreadsheet with many values by 1000 with out
> > going into each cell. I would need to turn ea. cell from a value to a
> > formula.

Reply to this Message

ryguy7272 - 11 Feb 2008 14:18 GMT

Here's a macro that will do it for you:
Sub DelZeros()

For X = 1 To 1
Dim redRng As Range
Set redRng = Range("A1:Z100")
For Each Cell In redRng
If Cell.Value <> "" Then
Cell.Value = Cell.Value * 1000
End If
Next Cell
Next X

End Sub

Adjust the range to suit...

Regards,
Ryan

Signature

RyGuy

> What do you mean by formula?
> >
> > >I need to multiploy a large spreadsheet with many values by 1000 with out
> > > going into each cell. I would need to turn ea. cell from a value to a
> > > formula.

Reply to this Message