Formula representation in a cell

D

DLESHAW

Version: 2008
Processor: Intel

all of my spreadsheets were written with the formats such as cell =a3*a5. all of a sudden, they are showing up in the formula bar in a format such as Cell = RC(-2)* RC(-3). the entries are written relative to the subject cell. I have no idea how hey got that way or how to change it back. Ther must be some simple toggle???

please email me direct
 
C

CyberTaz

Go to Excel> Preferences - General, uncheck "Use R1C1 reference style".

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
Top