how do I change the default name of a column from numbers to lett.

's Computer Specifications

my default used to be column a, column b etc, somehow it has been changed to
column 1, column 2 etc. how do I change it back? Because of the default
change it changes my formulas to sum(R[1] - C[2] etc.

's Computer Specifications

In EXCEL 2007 try the following:-

Office Button / Excel Options (lower right hand side) / Formulas (2nd option
down on left hand side) / Working with formulas (2nd option down on right
hand side) / make sure that R1C1 reference style is not selected (that is, it
does not have a green tick in it)

If my comments have helped please hit Yes.

Thanks!

"mac" wrote:

> my default used to be column a, column b etc, somehow it has been changed to
> column 1, column 2 etc. how do I change it back? Because of the default
> change it changes my formulas to sum(R[1] - C[2] etc.

's Computer Specifications

Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mac" <mac @discussions.microsoft.com> wrote in message
news:49BD053B-6324-4E2F-8EBF-(E-Mail Removed)...
> my default used to be column a, column b etc, somehow it has been changed
> to
> column 1, column 2 etc. how do I change it back? Because of the default
> change it changes my formulas to sum(R[1] - C[2] etc.

's Computer Specifications

tools>options>general>r1c1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"mac" <mac @discussions.microsoft.com> wrote in message
news:49BD053B-6324-4E2F-8EBF-(E-Mail Removed)...
> my default used to be column a, column b etc, somehow it has been changed
> to
> column 1, column 2 etc. how do I change it back? Because of the default
> change it changes my formulas to sum(R[1] - C[2] etc.

's Computer Specifications

In 97-2003 tools>options>general, then deselect R1C1 reference style

in 2007 office button, excel options>formulas under working with formula and
deselect the same check box

For future posts include Excel version

--

Regards,

Peo Sjoblom

"mac" <mac @discussions.microsoft.com> wrote in message
news:49BD053B-6324-4E2F-8EBF-(E-Mail Removed)...
> my default used to be column a, column b etc, somehow it has been changed
> to
> column 1, column 2 etc. how do I change it back? Because of the default
> change it changes my formulas to sum(R[1] - C[2] etc.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to setup A4 as a Default paper size on MS WORD 2003 not a LETT	itsupport75.1	Microsoft Word Document Management	3	7th Aug 2009 03:51 AM
How to remove dashes and slashes form a sequence of numbers & lett	Celticshadow	Microsoft Excel Discussion	3	14th Oct 2008 12:44 PM
Excel, change column of negative numbers to positive numbers?	Nita	Microsoft Excel New Users	3	27th Nov 2007 04:54 AM
Can I change a column of calculated numbers to absolute numbers?	=?Utf-8?B?S2F0ZSBCaXNzZWxs?=	Microsoft Excel Misc	3	25th Oct 2006 06:10 PM
How do I change the Labels at the top of each column back to lett.	=?Utf-8?B?S2VubmV0aA==?=	Microsoft Excel Misc	1	4th Nov 2004 09:01 AM