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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I tell if a cell has a formula in it? 2
how do I create formula for if a valuegreater that zero is added it shades another cell? 1
Formula staying as text in cell 2
Trouble editing directly into a cell 0
Can't see text in cell while typing 1
entering whole numbers: formula bar 2
Conditional formatting by number of characters in cell 2
automatically import data from a cell in oneworkbook to another workbook 3

Top