Thread: CELL REFERENCE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default CELL REFERENCE

Menu ToolsOptions and go to the General tab, and then check the R1C1 Style
checkbox

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pauline" wrote in message
...
The cell references on my spreadsheet are numbers. How can i change the
top
reference back to letters ?

The cell reference there fore reads


R12C1 instead of A12