Column headings to numbers and row headings to alphabets?
 

Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers
instead of alphabets and at the same time, the row headings are in alphabets
instead of numbers. Can anyone advice on how to rectify this?

J

Column headings to numbers and row headings to alphabets?
 

Try

Tools|Options|general tab
un-check R1C1

Mike

"Juliana" wrote:

Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers
instead of alphabets and at the same time, the row headings are in alphabets
instead of numbers. Can anyone advice on how to rectify this?

J

Column headings to numbers and row headings to alphabets?
 

Have another look at the sheet.

You may have numbers for column headers but I doubt if you have letters for row
headers.

To change the column numbers back to letters go to ToolsOptionsGeneral and
uncheck R1C1 Reference Style


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 01:12:01 -0700, Juliana
wrote:

Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers
instead of alphabets and at the same time, the row headings are in alphabets
instead of numbers. Can anyone advice on how to rectify this?

J