Multiply an entire spreadsheet by 1000 without going into ea cell

[Jacham]

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.

 

[Gaurav]

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

 

[Alden]

What do you mean by formula?

 

[ryguy7272]

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