Share via

excel cell format????

Anonymous
2011-10-27T16:42:05+00:00

My excel cells have changed their name from the normal letter: number format to a row: column number format. So instead of being C5 it would now be called R5C3. How do I change it back?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2011-10-27T16:46:55+00:00

Click File > Options.

Click Formulas.

Clear the check box R1C1 reference style.

Click OK.

Was this answer helpful?

2 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-10-27T17:29:35+00:00

    thank you so much!!!!

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2011-10-27T16:48:03+00:00

    Hi,

    File|Options|Formulas and un-check R1C1

    Was this answer helpful?

    0 comments