| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing by fixed number
I want to replace a number of cells on a worksheet with new values. These
new values will be the existing value divided by 0.8775. I realise I can do this by using EditPaste SpecialDivide - but I want to be able to see the division in the Formula Bar rather than just the end value. At the moment, I'm just going through on a cell-by-cell basis, and editing each one by hand. Is there a quicker way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Add formula based on a fixed number | Excel Worksheet Functions | |||
| Paste a function as a fixed number | Excel Discussion (Misc queries) | |||
Threaded Mode
