Excel relative cell name

Posted by ilc PM | on Wed, 27/10/2010 - 14:55 1220 2 comments | report

I have been sent a excel file where the column names are displayed as numbers as are the rows. So the cell that would normally be B3 is displayed as R3C2, row3 column2. I believe is called relative cell referencing.

How do I change this back to the norm?

Thanks in advance

Ian

Comments

There are 2 comments. Login or register to view them.

Using Excel 2007...

MarkP | Wed, 27/10/2010 - 15:09

Using Excel 2003...

patvanaalst | Wed, 27/10/2010 - 15:40