| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
In Excel how do I convert back from having row and column NUMBERS.
For unknown reasons the row and column numbering has changed from say "C7"
and "D10" to "R7C3" and "R10C4", presumanly "R" menas Row and "C" means Column. When I want to say multiply C7 by 10 with the result reporting in cell D10, the cell formula becomes: 10*R[-3]C[-1]. I don't care for this system, and I just want to get back to my old system. How do I do that? Thank you Willem Duyvesteyn |
|
#2
|
|||
|
|||
|
This is an easy fix: you may have accidentally changed a setting while
clicking about the menu. Please click Tools Options General and de-select "R1C1 Style". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| moving excel in word back to excel | Excel Discussion (Misc queries) | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| HOW DO I CONVERT SCANNED DOCUMENT IN PDF FORMAT BACK TO AN EXCEL. | Excel Discussion (Misc queries) | |||
Hybrid Mode
