View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
dennis dennis is offline
external usenet poster
 
Posts: 202
Default 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