Thread: CELL REFERENCE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default CELL REFERENCE

Pauline,

why don't you try it and see?

Pete

On Mar 20, 1:28*pm, Pauline wrote:
Hi * if I change my spreadsheets will all the formulas automatically change
Thanks for your help



"Bob Phillips" wrote:
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- Hide quoted text -


- Show quoted text -