My Column headers are numbers how do I change them to letters?

C

Cindy 2 cats

I have numbers across the column header and the row header. Normally the
column header is letters. so if I have ona cell that is the 2nd coulmn over
and 5th cel down it should be "B5" but on my excel program it is "25". I can
not enter any formulas into my excel prgrams this way? Can anyone help me?
 
F

Frank Kabel

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0003.html

--
Regards
Frank Kabel
Frankfurt, Germany

Cindy 2 cats said:
I have numbers across the column header and the row header. Normally the
column header is letters. so if I have ona cell that is the 2nd coulmn over
and 5th cel down it should be "B5" but on my excel program it is "25". I can
not enter any formulas into my excel prgrams this way? Can anyone
Click to expand...
help me?
 
A

Alan

Try Tools > Options > General. See if R1C1 Reference style is checked, if so
uncheck,
Regards,
 
Top