G Guest May 30, 2007 #1 Excell 2007 has decided to have cell references all numeric. I get R1C1 instead of A1. Any suggestions on how I can fix this?
Excell 2007 has decided to have cell references all numeric. I get R1C1 instead of A1. Any suggestions on how I can fix this?
G Guest May 30, 2007 #2 Should work as follows: in Tools -> Options -> General check the box for reference style (this works for Excel 2002, 2007 should be similar)
Should work as follows: in Tools -> Options -> General check the box for reference style (this works for Excel 2002, 2007 should be similar)
N Nick Hodge May 30, 2007 #3 In 2007 it's under the Office Button>Excel Options>Formulas>Working with formulas, uncheck R1C1 reference style -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/
In 2007 it's under the Office Button>Excel Options>Formulas>Working with formulas, uncheck R1C1 reference style -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/
