| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make a column of formulas all ROUND
I created a spreadsheet in which I have a column of formulas. Most of these
fomulas are simply pulling a single number off another sheet. I want to make all the formulas ROUND versions of the existing formula without having to go into each cell and making the change. They are not in order to which I can just make the first fomula a ROUND fomula and copy down. So, is there a way to select a range of cells and make the existing fomulas all ROUND versions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round formulas | Excel Worksheet Functions | |||
| Make array formulay to round a number then subtract 10 from it | New Users to Excel | |||
| Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| How do I round up or down using formulas? | Excel Worksheet Functions | |||
Threaded Mode
