reference format and column name
 

I have 2 problems, likely, related to some reference format in Excel 2003:
1) Column names are displayed in numbers, like rows;
2) When I type a reference to a cell, the formula contains letters R and C
and number of cells, the referred cell is away from the cell with the formula
(instead of a regular number of column and row).
I don't know how I got to this format. Please get me back to columns named
in letters, and regular type of displaying references.
Many thanks.

reference format and column name
 

hi
on the menu bartoolsoptionsgeneral tab
uncheck R1C1 reference (upper left)

Regards
FSt1

"MV" wrote:

I have 2 problems, likely, related to some reference format in Excel 2003:
1) Column names are displayed in numbers, like rows;
2) When I type a reference to a cell, the formula contains letters R and C
and number of cells, the referred cell is away from the cell with the formula
(instead of a regular number of column and row).
I don't know how I got to this format. Please get me back to columns named
in letters, and regular type of displaying references.
Many thanks.