| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula around a cell reference
I am trying to add a formula in a series of cells that already have a cell
reference. Example: (current) =B4 (change to) =round(B4,3) I have a long series of data that I want to preform a round function on but do not want to have to do this one by one since there are so many. Is it possible to add this formula without having to do this procedure one cell at a time? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding cell reference on a header | Excel Worksheet Functions | |||
| Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
| Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
| What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions | |||
| Adding Smart Tags to an unrecognized cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
