how do I change column numbers to letters

[Paul B]

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

 

[Dave Peterson]

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

Marie wrote:

 

[Bob Phillips]

Goto Tools>Options>General and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

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

 

[Marie]

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

 

[Marie]

Thanks
it says name does not resemble a reference??

 

[Dave Peterson]

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]

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