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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Try Tools > Options > General. See if R1C1 Reference style is checked, if so
uncheck,
Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
why are my column headers numbers instead of letters? 2
Change Excel column headers from numbers to letters 1
Excel sheet with numbers as column & row headers - How? 3
column headers changed from letters to numbers, how do I change ba 1
2007, excel column hdings are now numbered - how do I get letters 1
Why did my Excel column headers change from letters to numbers? 4
Column header format 5

Back
Top