Excel 03, how do you change the columns from numbers to letters. Both the
column and rows are setup as numbers, instead of the rows being numbers and
the columns being letters.

R1C1 setting in Tools, Options

Mike wrote:

Excel 03, how do you change the columns from numbers to letters. Both the
column and rows are setup as numbers, instead of the rows being numbers and
the columns being letters.

Tools / Options/ General tab; in the Setting area (near top) there is a box
"R1C1 Reference style"
When this is checked, column have numbers, when unchecked column have
letters
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mike" wrote in message
...
Excel 03, how do you change the columns from numbers to letters. Both the
column and rows are setup as numbers, instead of the rows being numbers
and
the columns being letters.

ToolsOptionsGeneral tab, Uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike" wrote in message
...
Excel 03, how do you change the columns from numbers to letters. Both the
column and rows are setup as numbers, instead of the rows being numbers
and
the columns being letters.

On Jan 15, 1:07*pm, Mike wrote:
Excel 03, how do you change the columns from numbers to letters. *Both the
column and rows are setup as numbers, instead of the rows being numbers and
the columns being letters. *

Tools/Options/general/R1C1 uncheck
Jay