| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update a part of format to external workbook
I have a round function getting data from external workbooks, the last part
of the formula is doing a *1000; all I want to do is update all the formulas to remove the *1000. The references to the external workbooks is strange, so I can't dink around with those. I've tried edit/replace and a macro, but my results are a deletion of the entire formula! :( Help! Thanks!!! -- Marv Lusk Boise Corporation |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF alternative to PULL that opens external workbook and grabs val | Excel Worksheet Functions | |||
| Cannot Format areas of a workbook | Excel Discussion (Misc queries) | |||
| Can references to cells be used as part of a workbook reference | Excel Discussion (Misc queries) | |||
| how can update the data in an excel workbook without opening it | Excel Worksheet Functions | |||
| Links only update when external workbook is open | Excel Worksheet Functions | |||
Threaded Mode
