View Single Post
  #3  
Old February 20th, 2010, 07:24 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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
.