View Single Post
  #3   Report Post  
Old February 20th 10, 07:24 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
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
.