Column references changed from letters to numbers
 

I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so
other folks can add a single row of information to the list.

Somehow, the column references changed from A, B, C ... to 1,2,3 ... while
the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet
corrupt?

Anyone know how this could have happened ... and how do I change it back?
The sheet was protected and the folks entering the data didn't have the
password. Is there some way to prevent it from happening again?

Thanks,
--
JoAnn

Column references changed from letters to numbers
 

Tools - Options - General Tab. Uncheck R1C1 Reference style

"JoAnn" wrote:

I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so
other folks can add a single row of information to the list.

Somehow, the column references changed from A, B, C ... to 1,2,3 ... while
the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet
corrupt?

Anyone know how this could have happened ... and how do I change it back?
The sheet was protected and the folks entering the data didn't have the
password. Is there some way to prevent it from happening again?

Thanks,
--
JoAnn

Column references changed from letters to numbers
 

Thanks, Dennis! That solved the problem.
--
JoAnn


"Dennis" wrote:

Tools - Options - General Tab. Uncheck R1C1 Reference style

"JoAnn" wrote:

I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so
other folks can add a single row of information to the list.

Somehow, the column references changed from A, B, C ... to 1,2,3 ... while
the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet
corrupt?

Anyone know how this could have happened ... and how do I change it back?
The sheet was protected and the folks entering the data didn't have the
password. Is there some way to prevent it from happening again?

Thanks,
--
JoAnn