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


"Jacham" wrote in message
...
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.