View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default Excell 2000--My column headings have changed from letters to n

The same thing happens in 2007! Go to excel options/formulas/working with
formulas. Un-toggle the R!C! reference style! Thank you thank you thank you!

"garfield-n-odie [MVP]" wrote:

In Excel, click on Tools | Options | General tab | uncheck the
"R1C1 reference style" box | OK.

Jay F wrote:

My column headings have changed from letters to numbers--don't know how it
happened--how can I change it back. Now, instead of "C1" I have
"3,1"--confusing, isn't it?