View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kelly
 
Posts: n/a
Default Excel columns are now numbered instead of lettered

Awesome! It worked. Now I can't help but wonder how in the world that
setting got changed in the first place. It was so weird--I had forwarded it
to other computers and it would be "normal." Thanks so much for your help!

"Barb Reinhardt" wrote:

Try Tools - Options - General
Uncheck R1C1 reference style


"Kelly" wrote:

Suddenly the columns in my Excell worksheet are numbered, not lettered. My
old worksheets are fine. However, when I open the program to a fresh
spreadsheet or go to this current one, both rows and columns are numbered.
My current worksheet has correct "answers" for formulas, but the actual
formulas are now really weird. Help! I've tried Help, Detect & Repair.