cell formula display

[clivehr]

Yesterday the display of a formula in a cell suddenly changed from direct referencing (e.g. g3/3) to indirect (e.g. R[1]C[-3]/3). I'm going boss-eyed counting back! Why did this happen? How can I return to the previous format? - I can't find the right option.

[sktneer]

Hi,
Welcome to the forum.

Click on File --> Options --> Formulas --> Under "Working with formulas", uncheck the box for R1C1 reference style --> OK

[jason.b75]

Did this start after running a macro?

I can't think of any reason it would be necessary for someone to make that change in order for their code to run, but it's still possible that they could have done it.

[clivehr]

Thank you sktneer - perfect!

[sktneer]

You're welcome. Glad your issue is resolved.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.