If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change column from numeric to alphabet?
I have numbers in both columns and rows. I would like to have letters
accrosss the top. Len |
#2
|
|||
|
|||
How do I change column from numeric to alphabet?
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 |
#3
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|