| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Temporary formatting of cell with focus | Excel Discussion (Misc queries) | |||
| Displaying temporary values on formula cells. Is this possible?q | Excel Discussion (Misc queries) | |||
| How do I adjust row height to set cell margins to zero? | Excel Discussion (Misc queries) | |||
| cell to adjust in another workbook when cell changes | New Users to Excel | |||
| formula for named cell/range using cell values | Excel Worksheet Functions | |||
Linear Mode
