Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there (or can there be) a macro or a function that changes a formula like
=C1*$R4 in =round(C1*$R4,0) etc. I have many spreadsheets with hundreds of formulas on each sheet that need to be rounded. I would have to change individually every single formula. Is there an easier way? It could be the "Replace" function if it worked with the possibility to change the formula on both ends at the same time such as (example from above): Replace: = With: =round( [####=Joker] ,0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How I need correct formula, that no t rounding? | Excel Worksheet Functions | |||
Rounding formula won't copy to other cells in column - why? | Excel Discussion (Misc queries) | |||
How do I get my formula to stop rounding up | Excel Worksheet Functions |