Change Excel column headers from numbers to letters

's Computer Specifications

I received an Excel file from another user. All of the column headers are
numbers rather than letters and all formulae cell references are relative
rather than absolute. How do I change back to the standard letter column
header and absolute cell address?

Thanks for the help,

's Computer Specifications

Tools|Options|general

Uncheck R1C1

Mike

"Dave" wrote:

> I received an Excel file from another user. All of the column headers are
> numbers rather than letters and all formulae cell references are relative
> rather than absolute. How do I change back to the standard letter column
> header and absolute cell address?
>
> Thanks for the help,

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why did my Excel column headers change from letters to numbers?	Linda Rae	Microsoft Excel Misc	4	24th Jan 2009 09:53 PM
In MS Excel, how do I change the column ref headers from numbers .	=?Utf-8?B?QnJ1Y2UgTGluZGZpZWxk?=	Microsoft Excel Misc	2	31st Jul 2008 12:30 PM
column headers changed from letters to numbers, how do I change ba	B Lutz	Microsoft Excel Misc	1	27th Apr 2008 02:58 AM
My Column headers are numbers how do I change them to letters?	=?Utf-8?B?Q2luZHkgMiBjYXRz?=	Microsoft Excel Misc	2	1st Oct 2004 07:34 PM
Re: How do I change column headers from letters to numbers & vice vers	Michael R Middleton	Microsoft Excel Charting	0	10th Sep 2004 03:00 AM