View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Put 1000 in an empty cell.
copy that cell
select your range of cells to adjust.

Edit|paste special|check multiply

Clean up that helper cell.

Mary wrote:

Further explanation, I have different numbers in about 2500 cells. I want to
multiply each number times 1,000 and have that product of the # in the cell
times 1,000 present in the cell.

"Mary" wrote:

is there a quick way to multipy a large group of numbers by 1,000?


--

Dave Peterson