how do I change column numbers to letters
 

how do I change column numbers to letters
 

Marie, tools, options, general, uncheck R1C1 reference style, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Marie" wrote in message
...

how do I change column numbers to letters
 

Tools|Options|General Tab|Uncheck R1C1 Reference Style.

Marie wrote:

--

Dave Peterson

how do I change column numbers to letters
 

Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Marie" wrote in message
...

how do I change column numbers to letters
 

it says name cannot resemble a reference.......any ideas??

"Paul B" wrote:

Marie, tools, options, general, uncheck R1C1 reference style, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Marie" wrote in message
...

how do I change column numbers to letters
 

Thanks
it says name does not resemble a reference??

"Bob Phillips" wrote:

Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Marie" wrote in message
...

how do I change column numbers to letters
 

That means that you (or another person) defined a name (insert|Name|define) and
used a name that looked like an address.

Change the name to something else when you get prompted (start it with an
underscore???).

Marie wrote:

Thanks
it says name does not resemble a reference??

"Bob Phillips" wrote:

Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Marie" wrote in message
...





--

Dave Peterson

how do I change column numbers to letters
 

yipee the underscore worked thank you very much, everything is normal
again!!!!!

"Dave Peterson" wrote:

That means that you (or another person) defined a name (insert|Name|define) and
used a name that looked like an address.

Change the name to something else when you get prompted (start it with an
underscore???).

Marie wrote:

Thanks
it says name does not resemble a reference??

"Bob Phillips" wrote:

Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Marie" wrote in message
...





--

Dave Peterson