Thread: Adjust cell values without a formula or temporary cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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?
Reply With QuoteReply With Quote