How do I change column from numeric to alphabet?
In EXCEL 2007:-
Office Button (top left hand corner)
Excel Options (lower right hand corner)
Formulas
- make sure that there is no tick in the box called:-
R1C1 reference style
If my comments have helped please hit Yes.
Thanks.
"Dave Peterson" wrote:
In xl2003 menus:
Tools|Options|General Tab|uncheck R1C1 Reference style.
wgfpshaky wrote:
I have numbers in both columns and rows. I would like to have letters
accrosss the top.
Len
--
Dave Peterson
.
|