Adjust cell values without a formula or temporary cell
 

I have a range of values that are all off by 1000. I simply want to
highlight the range and somehow indicate to multiply all values by 1000. I
don't want to create a temporary range, along with a formula, and then
convert to values and copy back. Is there an easy way to do this?

Adjust cell values without a formula or temporary cell
 

In an empty cell, enter 1000, copy the cell. Then select the range,
right-click paste special multiply ok.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ohpinion8ted" wrote:
I have a range of values that are all off by 1000. I simply want to
highlight the range and somehow indicate to multiply all values by 1000. I
don't want to create a temporary range, along with a formula, and then
convert to values and copy back. Is there an easy way to do this?