Column Heading Error
 

Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row
and column headings as numbers. It is very difficult to create formulas when
their are two sets of numbers.

How do I change the column heading to be letters?

Thanks!

Column Heading Error
 

From menu ToolsOptionsGeneral uncheck 'R1C1 reference style'

If this post helps click Yes
---------------
Jacob Skaria


"Gunther" wrote:

Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row
and column headings as numbers. It is very difficult to create formulas when
their are two sets of numbers.

How do I change the column heading to be letters?

Thanks!

Column Heading Error
 

Tools Options General R1 C1 (Uncheck)

HTH
Regards,
Howard

"Gunther" wrote in message
...
Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row
and column headings as numbers. It is very difficult to create formulas
when
their are two sets of numbers.

How do I change the column heading to be letters?

Thanks!

Column Heading Error
 

Thanks for the help!

"Jacob Skaria" wrote:

From menu ToolsOptionsGeneral uncheck 'R1C1 reference style'

If this post helps click Yes
---------------
Jacob Skaria


"Gunther" wrote:

Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row
and column headings as numbers. It is very difficult to create formulas when
their are two sets of numbers.

How do I change the column heading to be letters?

Thanks!