My permanent column headings are numbers (1, 2, 3, etc.) and not letters (A,
B, C, etc.), so i have numbers both across the top and down the left-hand
side. How do I change them to letters so that I can enter formulae?

Select ToolsOptionsGeneral Tab and
uncheck R1C1 reference style.
--
Karthi


"MaddyP" wrote:

My permanent column headings are numbers (1, 2, 3, etc.) and not letters (A,
B, C, etc.), so i have numbers both across the top and down the left-hand
side. How do I change them to letters so that I can enter formulae?

Thank you so much - it worked!

"Karthik" wrote:

Select ToolsOptionsGeneral Tab and
uncheck R1C1 reference style.
--
Karthi


"MaddyP" wrote:

My permanent column headings are numbers (1, 2, 3, etc.) and not letters (A,
B, C, etc.), so i have numbers both across the top and down the left-hand
side. How do I change them to letters so that I can enter formulae?

In the future, please refrain from
urgent help needed please

It turns off some people as we tend to treat ALL the same.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MaddyP" wrote in message
...
My permanent column headings are numbers (1, 2, 3, etc.) and not letters
(A,
B, C, etc.), so i have numbers both across the top and down the left-hand
side. How do I change them to letters so that I can enter formulae?