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