CELL REFERENCE
 

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

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

CELL REFERENCE
 

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

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 -