| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2)
Former version of Excel was easy and straightforward. However, our French
office has started usig the formula =SUM(R[-56]C:r[-1]c) to add columns which we do not understand and cannot change. Once we opened a document with this formula, it changed everything in Excel to this formula, as well as making the the column indicators numerical rather than alphabetical. We would like to change the formula and revert back to the standard Excel versions we use here in the US. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Threaded Mode
