| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace forumulas with the round function in one go
I am constantly working on spreadsheets and then realise I wish I had entered
the "round" function at the start. Instinctively I thought of Ctrl+H to replace but can't figure out how you would put a ,0) at the end. Also considered a macro with typing - F2, Home, =Round(,End, ,0) - but dont know how to get this to work over a large range of formulas. Any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Replace function | Excel Discussion (Misc queries) | |||
| The ROUND function | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
