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
|